Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Icon for Helper IV rankHelper IV
3 years ago
Solved

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

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.  
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 

     

Sean-OReilly's avatar
Sean-OReilly
Icon for Helper IV rankHelper IV
3 years ago

Thanks Anonymous 

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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