Forum Discussion
New Customer Sales
Thank you for your continued support.
Here is what is happening today.
| Legal Entity | Customer Name | Created Date | Invoice Date | Sales Current | Sales New |
| sxcn | Water Con | 1/30/2017 | 10/17/2017 | $27,210 | |
| sxcn | Water Con | 1/30/2017 | 5/31/2017 | $116,447 | |
| sxcn | Water Con | 1/30/2017 | 5/25/2017 | $241,631 | |
| sxcn | Water Con | 1/30/2017 | 5/5/2017 | $81,631 | |
| sxcn | Water Con | 1/30/2017 | 4/25/2017 | $163,262 | |
| sxcn | Water Con | 1/30/2017 | 4/25/2017 | $54,492 | |
| sxcn | Water Con | 1/30/2017 | 4/24/2017 | $27,210 | |
| sxw | Water Con | 6/8/2016 | 1/31/2017 | $25,261 | |
| sxw | Water Con | 6/8/2016 | 11/17/2016 | $3,360 | |
| sxw | Water Con | 6/8/2016 | 8/31/2016 | $25,407 | |
| sxw | Water Con | 6/8/2016 | 8/31/2016 | $2,856 |
The desired output should be the following is we can use the MIN CREATED DATE Measure.
| Legal Entity | Customer Name | Created Date | Invoice Date | Sales Current | Sales New |
| sxcn | Water Con | 1/30/2017 | 10/17/2017 | $27,210 | |
| sxcn | Water Con | 1/30/2017 | 5/31/2017 | $116,447 | |
| sxcn | Water Con | 1/30/2017 | 5/25/2017 | $241,631 | |
| sxcn | Water Con | 1/30/2017 | 5/5/2017 | $81,631 | |
| sxcn | Water Con | 1/30/2017 | 4/25/2017 | $163,262 | |
| sxcn | Water Con | 1/30/2017 | 4/25/2017 | $54,492 | |
| sxcn | Water Con | 1/30/2017 | 4/24/2017 | $27,210 | |
| sxw | Water Con | 6/8/2016 | 1/31/2017 | $25,261 | |
| sxw | Water Con | 6/8/2016 | 11/17/2016 | $3,360 | |
| sxw | Water Con | 6/8/2016 | 8/31/2016 | $25,407 | |
| sxw | Water Con | 6/8/2016 | 8/31/2016 | $2,856 |
I just cannot understand. Someone else will help you.
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!