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

DAX DAX Calculations
6

Hi Sam,

Thanks for your reply. I know this is very complex, the last week I’ve been struggling with this challenge.
I’ve made a dummy model with a few invoices, maybe we can use this model to count the customers and the amount of Sales:

Invoices_example
Invoices_example.JPG1011×546 106 KB

Further I’ve made an example of a report. The numbers is what count, not the format :wink:

Report_example
Report_example.JPG1065×513 125 KB

The relationship between the 2 tables:

Relationships_example
Relationships_example.JPG265×559 13.4 KB

Can you help me with the DAX-formula to count the number of customers for each year?

Thanks in advance,

Greetings from a rainy Holland,

Cor