Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculating Variance

I have a table (see below) that we are hoping to look at the variance PER ROW CELL.  Meaning.... if the ACTUAL number has a >20%, then that CELL will turn YELLOW.  if you look at the table below, you...
Need Help
Show and Tell
Tips and Tricks
  • rocky09's avatar
    rocky09
    4 years ago

    I hope, I understood your question properly.
    Try this.
    create a measure:

    _variance = 
IF(
AVERAGEX(data,
        data[Monday Agreed] - data[Monday Actual]) > 2,"#F5E633","#fff")

    Then, apply the conditional formatting of the column and select the measure.

     

rocky09's avatar
rocky09
Solution Sage
4 years ago

I hope, I understood your question properly.
Try this.
create a measure:

_variance = 
IF(
AVERAGEX(data,
        data[Monday Agreed] - data[Monday Actual]) > 2,"#F5E633","#fff")

Then, apply the conditional formatting of the column and select the measure.