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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
DomA001
Regular Visitor

DAX Help, customers new vs existing

Hi,

 

So I want to select any given month, which will return all the customers in that month only AND I then want to check those customers against a specific period to see whether they are a new customer or returning customer, what's the best way to go on about this?

 

Thanks

2 REPLIES 2
Anonymous
Not applicable

AlB
Community Champion
Community Champion

Hi @DomA001 

One option would be to:

1. Place Client_Name in the rows of a table visual

2. Create a measure that will return "Returning" for the clients present in the selected period and in the previous period and "New" for the others

3. Place that measure in the visual

 

Regarding point 2: if the previous period is fixed, for instance the 12 months before the selected period, you could hardcode it in the code. Otherwise you could create a one column table with the number of months to cover backwards from the current period, place it in a slicer, let the user choose it and read that value in your measure

You'd need to provide a sample of the data as example and be more specific about the expected result to get a more specific answer.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

 

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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