Conditional Format Overdue Date Based on Today

[emae613]

Good Evening-

I am stuck on Conditionally formatting an overdue date. If the date shown in the table is in the past from today's date, how do I write the DAX to highlight the background color red? Also, what steps do I take to apply the conditional format? My start date in the table is formatted as a date/time. The dataset will also be refreshed daily so I want to make sure this will stay a conditional format as the current date changes. Thank you! 

[ValtteriN · Accepted solution]

Hi,

You can create a measure like this:

DateFormatMeasure = IF(MAX(DateFormat[Date])>TODAY(),1,0)

Then go here:

And create a rule like this:
End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[emae613]

Thank you! That worked perfect. However, what if I wanted to format it based on current date and current time? Is there a way to do that? Thanks again for all your help I greatly appreciate it!