Forum Discussion
Complex colouring rows in a table
Hello LABrowne,
You have multiple ways of doing so. You can do everything inside a single measure but you can also split in 3.
First is your red line measure, second is your yellow one and the third is your main measure that you will use inside conditionnal formatting using SWITCH() function or IF statement.
I suggest to test them separately at first and then (if you want to not have 3 separate measure) mix the logic inside a big one with VAR RedLine = ... , VAR YellowLine = ... and RETURN IF(condition = X && condition <> Y, RedLine, YellowLine)
I hope it's clearer.
Vincent BLOT
Did I answer your question? Mark my post as a solution!
Thank you, that's what I'm doing step by step. the only part I'm stuck on is I have 2 different date columns - Delivery Date and Expiry Date how do I make a condition that the order has to active e.g. between those 2 dates?
Hello,
I'm not sure to really understand, can you share the measure maybe you are working on ?
From what I understand, it is another condition that you have, IF ( Date >= Delivery Date && Date <= Expiry Date, do something, do another thing).
Hope it helps
Yes so I guess it would be measure = IF ( TODAY() >= Order[DeliveryDate] && TODAY() <= Order[ExpiryDate] ).
However whenever I try any date formulas it doesnt recommend by two date columns (delivery and expiry date) Im not sure why.