Forum Discussion
DAX Calculated Column for Comparing Values on Non-Consecutive Dates In the matching context
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.
Thank you, DataNinja777! However, the date column does contain duplicates, which is why I included the index column. Apologies for not mentioning that earlier—I completely overlooked it.