Hi Sam,
Can you help me with another churn-question…?
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