Forum Discussion
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 ...
Hi,
You are welcome. Do not just share the formula - i will not be able to help you. Please descibe the business scenario, share some data and show the expected result.
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 |