Forum Discussion

inglexjc's avatar
inglexjc
Post Patron
3 years ago
Solved

Conditional Formatting Past Due Date

I want to show font color (Red) if the Due Date is Today or before today. Table name is TR_FSP_2 column is Date_Due. Case Name Date_Due Smith, j 10/06/2020 x, Greg 11/07/2022 Harris ...
Need Help
  • AilleryO's avatar
    AilleryO
    3 years ago

    It should be :

    FormatColour = IF(Today() >= [Date_due], "Red") 

    tells us if it works

AilleryO's avatar
AilleryO
Memorable Member
3 years ago

Hi,

 

TODAY is a function so needs parenthesis : TODAY()

To add to  inglexjc answer, notice taht the TODAY() date is the one from the machine where the report is running, ie :

your PC when on Power BI Desktop

or the server on Power BI Service (and then it depends on the location of the server...).

You can check this location in Power BI admin.

Hope it helps

inglexjc's avatar
inglexjc
Post Patron
3 years ago

AilleryO 

Okay I added the parenthesis but now get error about the 'timezoneoffset'.