Comparing New vs Lost vs Steady Customers over Multiple Years - Customer Churn Examples - Advanced DAX

Hi Sam,

Can you help me with another churn-question…? :slight_smile:

Instead of a yearly churn-comparison our company wants a quarterly comparison:

Additional information: this is dummy data en LTM means “Last Twelve Months”.

How do I have to change the formulas for the new - lost and steady customers?

For the totals of the dummy data I have

Total Customers LTM = 
CALCULATE(DISTINCTCOUNT(Invoices[Customer]);
    DATESBETWEEN('Calendar'[Date];
        NEXTDAY(SAMEPERIODLASTYEAR(LASTDATE('Calendar'[Date])));
        LASTDATE('Calendar'[Date])))

With kind regards,

Cor