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 :-

My Prior last month customer = 1000,

and out of 1000 , only 912 were in Last month ( so 88 got lost)

so %Churn rate would be = (1000-912)/1000 )= 0.088= 8.8%

note- 

The lost customer can’t include new customer in that period.

 

I am using the fiscal calendar.

 

Calculating the Prior last month  and last month by using this formula 

Prior last month Cust =
TOTALMTD([Disnt Customer],DATEADD(Table[Date],-2,MONTH))
 
last month Cust =
TOTALMTD([Disnt Customer],DATEADD(Table[Date],-1,MONTH))
 
Any help in calculating the % churn rate?
Thanks,
Tejaswi
 
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.

9 Replies

  • 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.