Forum Discussion
Solved
PowerBI Measure for Colouring Date Ranges
Hi, I'd appreciate some help with the following measure. I'm looking to colour the date value as follows: Red - Target Date has passed - Value "2" Amber - Target Date is due withing 5 days - Val...
Days that are in the future will have a negative difference with today, try
Colour = VAR _day = DATEDIFF ( MAX ( 'Sheet1'[Target Date] ), TODAY (), DAY ) RETURN SWITCH ( TRUE (), _day <= 0 && _day >= -5, 1, _day < -5, 0, _day > 0, 2 )
Days that are in the future will have a negative difference with today, try
Colour =
VAR _day =
DATEDIFF ( MAX ( 'Sheet1'[Target Date] ), TODAY (), DAY )
RETURN
SWITCH ( TRUE (), _day <= 0 && _day >= -5, 1, _day < -5, 0, _day > 0, 2 )
Amazing, that worked perfectly. Thank you so much for your help.