Churn of customers acquired in previous period

Anonymous — Fri, 12 Aug 2022 07:53:54 GMT

Hi guys and gals,

Working for a subscription service I am trying to figure out the number and value of susbcriptions and customers who ended their subscription after pre-defined periods (e.g. 1 month, 2 months etc.). For this I do have a Subscription table with subscription details (subscription ID, customer ID, start date, end date, payment frequency, year value), a Transaction table with all detailed transactions (subscription ID, customer ID, transaction ID, transaction date, transaction amount) and a standard Calendar table. In the model, the date of this date table is connected to the start date in the Subscription table and the transaction date in the Transaction table.

The DAX measures I wrote are like:

ChurnSubscriptionLT030Days# =

CALCULATE(

[TotalSubscriptions],

DATESINPERIOD(Subscription[startdate], MAX(Subscription[startdate]),-30,DAY),

DATESINPERIOD(Subscription[enddate], MAX(Subscription[startdate]),-30,DAY)

)

When viualising these measures in a bar graph with the measure on Y-axis and the calendar month (MONTH('Calendar'[Date]) on X-axis the numbers are incorrect. I am sure the solution is simple so I am hoping you can help me out.

Re: Churn of customers acquired in previous period

amitchandak — Fri, 12 Aug 2022 09:36:55 GMT

Anonymous , Create current vs last period as I have done in the HR file(On the trend Page). Then you can check blank and nonblank values for customer retention

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497

topic Churn of customers acquired in previous period in DAX Commands and Tips

Churn of customers acquired in previous period

Re: Churn of customers acquired in previous period