Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mblonkatf
Frequent Visitor

Measure to show up new customers per month

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 iddate
A2-1-2019
B2-1-2019
A16-1-2019
C30-1-2019
D2-2-2019
D3-2-2019
A7-2-2019
B15-2-2019
E20-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

1 ACCEPTED SOLUTION
TeigeGao
Solution Sage
Solution Sage

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:

Snipaste_2019-04-15_14-10-24.png

Best Regards,

Teige

View solution in original post

3 REPLIES 3
TeigeGao
Solution Sage
Solution Sage

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:

Snipaste_2019-04-15_14-10-24.png

Best Regards,

Teige

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

 

thx pro,

jthomson
Solution Sage
Solution Sage

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.