I’m very interested in calculating Customer Life time value (CLTV) form the Cohort analysis showcase available on youtube:
I started creating the needed DAX formulas to calculate (CLTV), For more information about the formulas please refer to this (2) links:
2-For calculate customer life-span: https://www.quora.com/How-do-you-calculate-customer-lifespan
According to the information of the 2 references links above , I did complete preparing all the ingredients, In order to calculate the Churn Rate%, After calculating the (Retained Customers) and then (Churned Customers) , Churn Rate% = 1-((Retained Customers)/(Churn Customers))
Based on the steps I described above I have some doubts is the calculation of the Churned Rate% steps are correct?
Note: I attached the reource on the following link:
All the calculation measures available on the resources.