Forum Discussion

xpisoverated's avatar
xpisoverated
Regular Visitor
24 days ago
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 ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    13 days ago

    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.

MasonMA's avatar
MasonMA
Super User
24 days ago

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.
xpisoverated's avatar
xpisoverated
Regular Visitor
24 days ago

Thanks Pivot works perfectly, one question, if i pivot on the date, so in effect my table visual is

Name,Date1,Date2,Date3

 

Is there an easy was to add a column or measure after date3 that shows if the value in date 1 and 2 has increased, decreased or stayed the same ?

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    13 days ago

    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.