Forum Discussion

aar1's avatar
aar1
Regular Visitor
3 years ago
Solved

Conditional Formatting based on 2 Measures

I have a column of due dates and I want to check if 60 days have passed since the due date. If so, I would like to apply conditional formatting and highlight late entries in yellow.  If 120 days hav...
Need Help
  • rsbin's avatar
    rsbin
    3 years ago

    aar1 ,

    You do not need to create separate measures.  Create a new Calculated Column:

     

    DaysPastDue = DATEDIFF( [DueDate],  Today(), DAY )

     

    DueDate         DaysPastDue

    01/15/2023 152
    04/15/2023 62
    05/15/2023 32
    06/16/2023 0

    Then base your conditional formatting on this calculated column.  Follow these steps:

    I trust this is close to what you are looking for and helps you on your way.

    Regards,

rsbin's avatar
rsbin
Community Champion
3 years ago

aar1 ,

You do not need to create separate measures.  Create a new Calculated Column:

 

DaysPastDue = DATEDIFF( [DueDate],  Today(), DAY )

 

DueDate         DaysPastDue

01/15/2023 152
04/15/2023 62
05/15/2023 32
06/16/2023 0

Then base your conditional formatting on this calculated column.  Follow these steps:

I trust this is close to what you are looking for and helps you on your way.

Regards,