New Customers Calculating Incorrectly

DAX
1

Hi All,

I am just trying to get the total for new customer sales to total correctly as I want to be able to show this measure by month, and also by month and customer ID.
I’m getting a dif answer to when I calculate it in Excel The New Customer Sales calc at the moment doesn’t take only the first order of the new month (sums the total orders if a customer is new in the month) which is OK by me as we will be looking at the month results, but I cannot work out what the “New Customer Sales Fix” is calculating.

New Customers.pbix (145.8 KB)

image
image1034×590 40.8 KB

New Customer Test Correct.xlsx (50.5 KB)

I’ve had a look at some other posts New/Lost Customers not totaling correctly but would appreciate some help with this one. Thanks!

2

Bumping this post for more visibility from our experts and users.

3

Hi @Juju

Due to inactivity, we’d like to conclude that your inquiry was out of the experts’ and users’ bounds.

If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.

While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!