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?
