Forum Discussion
Stevendelaro
2 years agoNew Member
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
- samratpbiSuper User
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