Forum Discussion
Solved
Getting a value into a column from the same table
I'm sure i'm missing something obvious, but here goes I have a sharepoint folder with 3 csv files in it, i bring them all into a single table via the folder import. One of the columns in the table ...
Hi xpisoverated
Yes, you can definitely add logic to compare values across pivoted dates. Since your table visual is showing Name, Date1, Date2, Date3, you want a measure that checks the difference between Date1 and Date2, then returns a text label like Increased, Decreased, or No Change.
Since the data already contains the filename, you can do this in Power Query instead by Pivot Column.
Use Score as the Values column. (Under Advanced options, choose Don't Aggregate)
If you still need the original row structure, you can merge this pivoted table back onto the original table. This is generally simpler to maintain than creating one DAX calculated column per month.