Forum Discussion
Solved
DAX Calculated Column for Comparing Values on Non-Consecutive Dates In the matching context
Hi everyone, I'm working on a DAX calculation in Power BI where I need to compare a value on a given date with the value on the previous date for the same context of Product, Partner, Projection, an...
Thank you, everyone, for your input! I wanted to share that I found the solution I was looking for right here on the forum. The method to compare values across non-consecutive rows was simpler than I thought and was already discussed in this thread. I hope this helps someone in the future as it did for me. Cheers!
Since the date column doesn't seem to contain duplicates, it appears that we may not need to use the index column.
The resulting output is shown below.
Please let me know if this meets your expectations.
I have attached an example PBIX file for your reference.