Day on Day change with drill through causing discrepancies when checked for individual data points

afaro — Tue, 23 Apr 2024 18:44:52 GMT

I have the current scenario so far:

Product	Description	Price	Date
X	Version1	20	2024-04-22
X	Version1	20	2024-04-23
X	Version2	20	2024-04-24

I am calculating the day on day using PREVIOUSDAY() function.

I have the dates on the x axis and the day on day change on the y axis.

I have a drill through day on day change with the date which shows me for every product the change.

The problem is I see that the correct day on day change overall is 0 on 2024-04-23 and 2024-04-24, however whenever I drill through on these dates and see a table with individual products and their day on day change, I see for 2024-04-24 that there is a positive change of 20 which is likely due to the description column changing which it considers it to be a new product altogether even though I don't want to see that. How do I write a dax query that would only consider a new row to be one where the main key i.e. Product is changed?

Re: Day on Day change with drill through causing discrepancies when checked for individual data points

Anonymous — Wed, 24 Apr 2024 01:56:07 GMT

Hi, afaro

Didn't reproduce your data, you can share the pbix file without sensitive data for understanding and testing.

Best Regards,
Yang
Community Support Team

topic Day on Day change with drill through causing discrepancies when checked for individual data points in DAX Commands and Tips

Day on Day change with drill through causing discrepancies when checked for individual data points

Re: Day on Day change with drill through causing discrepancies when checked for individual data points