Forum Discussion
New,Lost,Existing Customer Count -- Dax Help
Hello, I just want to count new,lost,existing customer. Below are my data and scenario Emp Name EMP iD Date Month A 101 4/30/2020 Apr B 102 4/30/2020 Apr C 103 4/30/2020 Apr...
Anonymous
I have worked out a solution that you can find in the attached PBIX file. Hope it answers your questions.
I added a calendar table as well. Modify your table and field names as necessary.
Download: https://1drv.ms/u/s!AmoScH5srsIYgYIRa-ntfQ0YKA50IQ?e=Pmq6KZ________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
amitchandak
Super User
Super UserAnonymous , refer if this solution can help
https://community.powerbi.com/t5/Desktop/Churn-Rate-lost-Customer/m-p/1173754#M529196
There is pbix , which was also shared
amitchandak
Thanks for sharing..Let me see this post if it meets my requirement or not.. I will let you know..