Customer Churn Calculation

Question

Hi,&nbsp;I am trying to do a calculation with the following logic:&nbsp;Churn = Current period's active customers - Current period's new customers - Previous period's active customers&nbsp;The dates can be drilled down to weeks or up to months, quarters or years. I wonder if it's possible to create a measure in DAX to calculate this regardless of what time granularity is selected so it still shows shurn.I would really appreciate help. Thank you.

amitchandak · Answer

tpoltorak , refer if these blogs can help
Customer Retention Part 1:https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458
&nbsp;
Customer Retention Part 5: LTD Vs Period Retentionhttps://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497

Forum Discussion

Customer Churn Calculation

1 Reply

Related content

calculating churn

Calculation help - churn

Customer Churn Analysis

Customer Churn Rate

Last rolling sales for churned customers