Forum Discussion
Solved
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...
File attached.
DimaMD
Solution Sage
Solution SageHi, Martijn1204 You can read this article here, it is well described how to identify new customers
https://www.daxpatterns.com/new-and-returning-customers/
Hi,
I also found this article but I can't find that they define "new customers" as customers who purchased something in the first 12 months of their purchase. I now how to define "new customers" as customers who purchased something for the first time in month A. And when it is month B, these customers aren't defined as "new customers".