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

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)

       

      • 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