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 

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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