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.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

I have understood what you want , but I need a sample data model.

Please give me the relevant sample table data and explain the relationship between the tables.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Lionel for your reply!

 

Please see attched pbix sample file.

Also attaching the excel spreadsheet for more detailed information. 

 

Appreaciate your reply!

 

Thanks,

TD

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-lionel-msft  ,

       

      Did you get a chance to look at it?

      Appreciate your help!

       

      Thanks,

      Tejaswi

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Anonymous ,

         

        Pls see if this is what you need.

         

         

         

        Last month Cust =
        CALCULATE([Distinct Cust], FILTER(ALL('Fiscal Calendar'),'Fiscal Calendar'[Moth1] = MIN('Fiscal Calendar'[Moth1]) - 1 ))
         
        Prior last month Cust =
        CALCULATE([Distinct Cust], FILTER(ALL('Fiscal Calendar'),'Fiscal Calendar'[Moth1] = MIN('Fiscal Calendar'[Moth1]) -2 ))
         
        Churn% = DIVIDE([Prior last month Cust],[Last month Cust])
         

        Regards,
        Harsh Nathani

        Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)