Forum Discussion
Getting a value into a column from the same 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.
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 ?
Community SupportHi 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.