Thursday, 21 July 2016

Cohort Analysis

Find out how many of our customers are coming back after their first purchase. We need to group the customers by when the made their first purchase as well as where they made their first purchase.


Step 1: 

Find the first Order Date for each Customer by finding the minimum Order Date per Customer. 



Step 2: 

Find the region each customer first bought in


Step 3: Calculate percent difference 

 Step 3.1: First create the Current Count calculation.


   Step 3.2: Next create the Cohort Count calculation


    Step 3.3: 
    Find the percent difference between the number of returned     customers each month and the total count of customers in         the cohort. 
  



Step 4: Design a View

 Drag "Order Date" on Columns and "First Purchase date" on Rows. 





Drag "First region" on Rows.


 Drag "Percent from First purchase" on Text for final output. 





Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks