Forum Discussion
Loyal Vs Risk Customers
Hi guys, I would like to to see the DISTINCTCOUNT of Customers that have purchased in the last 3-12 months and also that havent purchased in the last 2months. I have thought about Virtual tables/...
Please provide sample data or PBIX file. Thanks!
Hi PaulDBrown, The data I am using is sensitive. But I will try to come up with a mock up. I am assuming you haven't encountered a scenario like this before!
Thanks
It's a variation of the "new (and/or lost) customers" calculation. Yet it's much more productive to work on an actual model than to imagine tables/relationships/measures. So a mock up would be really helpful.
Also please clarify what "in the last 3-12 months" means (customers who made purchases within Today - 3 months to Today-12 months?
A depiction of how you wish to present these calculations is also needed.