Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My data set looks like this
Customer | Sales Date |
---|---|
Cust1 | 02/12/2017 |
Cust1 | 03/12/2017 |
Cust2 | 03/14/2017 |
Cust2 | 02/15/2017 |
Cust3 | 05/12/2017 |
Cust3 | 06/12/2017 |
What i need to find out is
the first sales date of each customer and and then find the count of customer in each month to which their first sales date belongs to.
for example:
The first sales date of Cust1 and Cust2 are 02/12 and 02/15 respectively.
So the chart should say something like this.
Similarly the first sales date of Cust3 is 05/12 so May will have count of 1
Month | Number of customer |
---|---|
Feb | 2 |
May | 1 |
There is also a master calendar on Sales date available in the data model.
Thanks,
Jean
Check attached
May be this
Dimension
Aggr(Month(Min([Sales Date])), Customer)
Expression
Count(DISTINCT Customer)
Check attached