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.
Solved! Go to Solution.
If you're running it on your PC or on a server within the same time zone as yours, TODAY() is fine and so you don't need that part, just TODAY().
Otherwise replace by a value (ie 7 if you're 7hrs ahead of US and your report will be published on a US Server)
I am running on my computer for my time zone. So if I take it out (timezoneOffset / 24). Should I also take out todayInYourTimeZone?
var = TODAY ( )
return IF(Today >= [Date_due], "Red")
And get sytax error:
Your probem is that your're creating a measure and you should use a column for this formula. So it is not because your column doesn't exist, it's because a measure doesn't have a row context whereas the column will have a row context.
So if you create a new column (not measure) with the same formula it should work.
Let us know
There is a function called TODAY() that will return the curernt day (in UST time), which you can add (time zone offset / 24) to, depending on your timezone.
So you can create a measure like so:
var todayInYourTimeZone = TODAY + (timezoneOffset / 24)
return IF(todayInYourTimeZone >= [Date_due], "Red")
And use conditional formatting on your table to format the cells where the cell is overdue.
I am getting an error when creating this measure: "Failed to revolve name 'TODAY'. It is not a valid table, variable, or function name." Suggestions?
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.