Forum Discussion
Churn Rate - lost Customer
HI,
I want to have the Prior to Last Month Customers and compare that to the last month Customers to see if those exist in the last month than calculate the churn rate
For example :-
M...
Anonymous , The number distinct customer not matching in excel and pbix.
Anyways, I have calculated the same customer and lost a customer. With that you can get the churn
File is attached. Added customer table and mark Calendar table as Date table.
amitchandak
Super User
Super UserAnonymous , The number distinct customer not matching in excel and pbix.
Anyways, I have calculated the same customer and lost a customer. With that you can get the churn
File is attached. Added customer table and mark Calendar table as Date table.
MAAbdullah_47
Helper V
Helper VHi amitchandak
how we calculate the churn rate for lost and new customers as it is introduced on this post :
https://www.daxpatterns.com/new-and-returning-customers/
Thank you