Forum Discussion

Stevendelaro's avatar
Stevendelaro
New Member
2 years ago
Solved

DAX for conditional formatting to compare two columns

Hi, can someone help to create a Dax, to compare the two columns showing below

 

 

  • Hi,

     

    You can simply create a measure to compare your existing measures or columns. e.g. here 
    Measure1 = [WTD 550 Release Plan %] - [550 Target %]
    Now, use that measure to any conditional formatting. e.g. if value > 0 then Red / Green and vice versa.

     

    Hope this resolves your problem.

    If it does, then please mark this as solution. Thanks

1 Reply

  • Hi,

     

    You can simply create a measure to compare your existing measures or columns. e.g. here 
    Measure1 = [WTD 550 Release Plan %] - [550 Target %]
    Now, use that measure to any conditional formatting. e.g. if value > 0 then Red / Green and vice versa.

     

    Hope this resolves your problem.

    If it does, then please mark this as solution. Thanks