Forum Discussion
Calculate difference between multiple columns and then highlighting the difference
Hello I am trying to calculate the difference between mutiple columns in PowerBI. And Highlight changes above and below 50 w/ color. I haven't been able to find any examples with multiple colum...
Hello,
if you want the differences between two columns, you can do this : measure = SUM(Sum of 1) - SUM(SUM of 2).. etc
if you want the differences in % to do a highlight when the differences is > than 50%, you should do something like this, and use the pourcentage as a "cell elements" :
Pourcentage = DIVIDE(SUM('Table (2)'[Value 2]) - SUM('Table (2)'[Value 1]),SUM('Table (2)'[Value 1]) )
If your columns are something like a date, or months, you should think about do a pivot to get thoses columns in rows. And then use DAX date functions to compare thoses dates.
If your columns are something like a date, or months, you should think about do a pivot to get thoses columns in rows. And then use DAX date functions to compare thoses dates.