Forum Discussion

Eric_Guli's avatar
Eric_Guli
Frequent Visitor
8 years ago

New Customer Sales

Hello Power BI Community,   I am looking for a solution on capturing New Customer Sales but I have the following issue that I haven't been able to overcome. We have three (3) Legal Entities in our ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

I just cannot understand.  Someone else will help you.

Eric_Guli's avatar
Eric_Guli
Frequent Visitor
8 years ago

Thank you again. Yes, this has been the problem from the begining to write a DAX expression that can look for the Min Customer Created Date regardless of the Legal entity it may belong to. We have the same customers in multiple entities and trying to look only at who is actually a "NEW" has been the challenge. So in the example above the custoemr Water Con was set up in 2016 in SWX legal entity so they were new in 2016. In 2017 the customer was setup under SXCN legal entity and now shows as a new customer when in fact it isn't. 

 

Thanks!