Measure to show up new customers per month

[mblonkatf]

Hi,

I would like to get te amount of new customers over the period i have available in my dataset. the set is build up like:

cust id	date
A	2-1-2019
B	2-1-2019
A	16-1-2019
C	30-1-2019
D	2-2-2019
D	3-2-2019
A	7-2-2019
B	15-2-2019
E	20-2-2019

I would like to show the amount of new customers per month in a waterfall visualization. So in january it would show up 3 customers and in february it would show 2 new customers. Right now, if I use a distinct count on customer id, it returns the amount of distinct customers per month. So 3 in january and 4 in february. Can someone help?

Michel

[TeigeGao · Accepted solution]

Hi @mblonkatf ,

In your scenario, we can first create a calculated table to get the New date for each customer using the following query:

Table = SUMMARIZE(Data,Data[cust id],"New_date",MIN(Data[date]))

Then create a calculated column to get the month like below:

Month = 'Table'[New_date].[Month]

After that we can create a measure like below:

Measure = CALCULATE(COUNTROWS('Table'))

The result will like below:

Best Regards,

Teige

[HEMOglobin]

thx a lot, its exactly what i'm looking for 🙂

thx pro,

[jthomson]

Should be quite easy to find a formula to create a new column showing the first date for each customer, which you can then use the same calculation you've got at the moment, except it'd work