Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous 

Thanks Fr your reply!

 

Unfortunately this is not what I am lookign for.

 

Did you see my sample .pbix file, and also Spreadsheet attached . I have my relationships shown in the file and also in spreadsheet i have given the detailed explaination.

 

Please let me know for any additional info.

 

Thanks,

TD

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak  May be you can help me with this request.

 

Appreaciate it.

 

Thanks,

Tejaswi