Forum Discussion
Lost Customer
- 6 years ago
Please try an expression like this:
Lost Customers = VAR __3mosago = EDATE ( MIN ( 'Date'[Date] ), -3 ) VAR __4mosago = EDATE ( MIN ( 'Date'[Date] ), -4 ) RETURN COUNTROWS ( FILTER ( ALLSELECTED ( REVENUE[customer_id] ), AND ( ISBLANK ( CALCULATE ( COUNTROWS ( Revenue ), ALL ( 'Date' ), 'Date'[Date] >= __3mosago ) ), NOT ( ISBLANK ( CALCULATE ( COUNTROWS ( Revenue ), ALL ( 'Date' ), 'Date'[Date] >= __4mosago ) ) ) ) ) )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
HI Anonymous ,
Have a look at these blogs.
https://radacad.com/customer-retention-in-power-bi-dax-measures
https://radacad.com/lost-customers-dax-calculation-for-power-bi
https://blog.enterprisedna.co/analyze-who-your-lost-customers-are-using-power-bi-dax/
https://blog.crossjoin.co.uk/2010/05/03/counting-returning-customers-in-dax/
Regards,
Harsh Nathani
Regards,
- Anonymous6 years agoNot applicable
Anonymous
Thank you for the links. I've actually visited all of those before, and I am still not getting the number that I want. I know I am missing something.https://blog.enterprisedna.co/analyze-who-your-lost-customers-are-using-power-bi-dax/
I've created DAX based on the above link, but for some reason, for any given month, the number is showing for the month prior.
The Aug 2019 amount shown on the above chart is actually for Jul 2019.
My formula is this one below.