How Do I Conditional Format a Date to go Red if before Today's date?

[Sean-OReilly]

Hi

How Do I Conditional Format a Date to go Red if before Today's date?

Here is my sample data - If End Date is before Today, i want it to go Red.

[Sean-OReilly]

thanks @reidnmorrison 

[Sean-OReilly]

Thanks @reidnmorrison 

How do I turn my End Date into a measure? At the minute it is just a field within a table and i can't bring it into the formula like you have done above

[reidnmorrison]

That should be a column reference not a Measure, I misread the column name. If you replace [End Date] with 'Table'[End_Date] that will do the trick. I'll edit the other reply to show that

[reidnmorrison · Accepted solution]

You can create a measure like this 

Colour_Date = 
VAR date_diff = DATEDIFF(TODAY(), MAX('Table'[End_Date]), DAY)
RETURN
    IF (date_diff < 0, "#C81517")

and then apply it as a conditional format to the column. The "#C81517" is HEX code so can be changed to a different red if you want

Post edited to correct table reference in the measure