Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi, can someone help to create a Dax, to compare the two columns showing below
Solved! Go to Solution.
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
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!