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.
In the power query,
Click Month column and Pivot under transform using Score as Values.
Output: