Forum Discussion
Martijn1204
3 years agoFrequent Visitor
Defining new customer
Hi all, I am a bit stuck with a difficult DAX function and I just can't get my head around it so maybe you guys can help me. I want to define new customers and old customers, starting from th...
- 3 years ago
File attached.
daXtreme
Solution Sage
3 years agoFile attached.
Martijn1204
3 years agoFrequent Visitor
Hi,
Thankyou alot, this really helps.
Apologies for the late reaction as I had to tackle some urgent projects.
This is exactly what I needed but there is an exception.
If their first purchase was on 01/01/2000, they are a "new customer" until 01/01/2001 (period of 12 months). But if they haven't bought anything in the upcoming 12 months, so from 01/01/2001 till 01/01/2002. They switch from "new customer" to "support customer". Do you think this is also possible?