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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mordonez
Frequent Visitor

New Customers , Active Customers and lost Customers

Hello : 

I have a Sales Table where i have the following fields : 

Date

ClientID

SKU

Sales 

And a date table with mi dates dimentions 

I try to lookup in the forum for this solution , but some are really advanced and i cant understand it 

What i need to do is get the count of customers by month  with this caracteristics :

New customers : are the customers wich NEVER buy a product in the past and now buy something  (from historyc date)

Active Customers : are the customers who as bought anything in the last 3 months 

lost Customers : are the customers who dont buy anything in the last 3 months 

 

i tried this but i can get the results i need 

 

Active Customers =
VAR
CustomerList=ALL('Sell Out'[ID])
VAR
ChurnDate = 2
RETURN
COUNTROWS(
FILTER(
CustomerList,
CALCULATE(COUNTROWS('Sell Out'),
FILTER(ALLSELECTED('Calendar'),
'Calendar'[Month]>(MIN('Calendar'[Month])-ChurnDate)&&'Calendar'[Month]<MIN('Calendar'[Month])))=0))
2 REPLIES 2
amitchandak
Super User
Super User

@mordonez , a small modification in the measure from this blogs can help.

 

please check

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

Thanks , but i dont understand how to avoid the filter you use to compare current month and past month 

What i need to archieve is to know hoy many new customers i have in each month who never bought in the past 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors