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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Mdobbels
Frequent Visitor

Measure to calculate which customers are New/Current/Lost

I would need a measure to divide my clients into the categories: Lost, New and Current.

 

The definitions for these categories are:

New= No Revenue before this year
Lost= No Revenue in the last 3 months (and not new)

Current= Not New nor Lost

 

Extra difficulty. As the information is coming in after closing we should actually make it so that "Before last year" is actually in the year before the last revenue was uploaded.  (The December 2021 information is in the refresh around January 6th, so as long as the January 2022 is not uploaded, before last year should be 2020) 

 

The same difficulty also applies to the definition of "Last 3 months)

 

Thank you in advance.

 

 

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@Mdobbels Check out New and Returning Customers: https://community.powerbi.com/t5/Quick-Measures-Gallery/New-and-Returning-Customers/m-p/168297#M13

 

I also have a many similar calculations for customers in DAX Cookbook. Chapter 6: PacktPublishing/DAX-Cookbook: DAX Cookbook, Published by Packt (github.com)



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler ,

 

Is it in your solution possible to see which clients are the new, lost and current customers?

Because I don't want to count them, I want to know which customers are new or lost so that Sales can act upon this information.

 

Kind regards,

Matthias

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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