Forum Discussion
Solved
Conditional formatting of date based on filter value
Hi I'm just after some advice on how I can highlight rows which have not had comments in red and not had comments in the last two weeks in amber. Data Structure Status Reporting Mo...
Hi
I have just resolved this with the following DAX measure
Days since update =
VAR SelectedDate = MAX('Status'[Reporting Month])RETURN
DATEDIFF(CALCULATE(
MAX('Update'[Update Date]), ALLEXCEPT('Status','Status'[ID])),
SelectedDate,
DAY
)
)
Hope this is of use to someone.
Hi
I have just resolved this with the following DAX measure
Days since update =
VAR SelectedDate = MAX('Status'[Reporting Month])
RETURN
DATEDIFF(
CALCULATE(
MAX('Update'[Update Date]), ALLEXCEPT('Status','Status'[ID])),
SelectedDate,
DAY
)
)
Hope this is of use to someone.