@Melissa Appreciate your time and effort on this question. It is interesting that your solution does work on the first reporting month only, and not for the remaining months. I will play around and see if I can tweak the code to get the other months to show (Feb-15: 2 new customers, Mar-15: only one new customer). Once I manage to get a solution, I will share the update in here.
I’m happy to help but it’s important for me to understand the logic and every element in play.
At this time we have two conflicting rules:
First in the case of Jan 2015 we exclude all Service Start dates that predate the Reporting Month
But then in all other cases we only have Service Start dates that predate the Reporting Month
So there must be other contributing factors I’m not aware of… Can you help me out with that?
Correct, and that should apply to all the reporting months. Meaning: the new customer is identified whenever a start service is within the selected reporting month. Should the customer have a starting service before the selected month, this would be an old customer.
Based on the above, Jan 15 should have 4 new customers, Feb 15 should have 2 new customers, and May 15 would have only one new customer.
2- Measure Customer Status = VAR CountCustomers = //counts old sales per customer CALCULATE ( SUM ( Data[CountCustomers] ), ALLEXCEPT ( Data, Data[Customer]) ) RETURN //if CountCustomers = 0 then new customer IF ( CountCustomers = 0, "Old", "New" )
Hi @Hesham, I hope that you are having a great experience using the Support Forum so far. We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!