Forum Discussion
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 have passed since the due date I would like to highlight the entries in red.
I have created 2 measures, one checking if its 60 days late and another checking if 120 days late. If today's date is less than 60 days or 120 days past or if the value is blank the measure returns 0. If not it returns 1.
Measure 1:
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,
1 Reply
- rsbinCommunity Champion
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,