conditio
1 Topic
Conditional Formatting using DAX
Hi, I'm trying to write a Dax measure for conditional formatting to occur in the below table as follows - Staff ID's that have a "Yes" in "LSL Accrued >2 Years", blank in "LSL Accrued >3" and if the figure in 'accrued leave (days) is different to the figure in 'Leave booked' show as Orange Staff ID's that have a Yes in both LSL Accrued >2 Years and LSL Accrued >3 Years and have a figure in accrued leave (days) that is different to leave booked show as Red. Table would look like this - Staff ID LSL Accrued >2 LSL Accrued >3 Leave booked Accrued Leave 1233456 Yes 0.0 10.0 1324644 Yes Yes 10.0 10.0 1238751 5.0 10.0 1325482 5484184 Yes 14.0 14.0 484564 128796 Yes Yes 10.0 12.0 1254844 Yes Yes 22.0 22.0 1258796 Yes 5.0 20.0 123846 Yes Yes 20.0 35.0 58974 7.0 14.0 123658 Yes 0.0 25.0 Would really appreciate any help! Pragati11 Thank you 🙂Solved1.4KViews0likes6Comments