topic Re: Conditional Format Overdue Date Based on Today in DAX Commands and Tips

Conditional Format Overdue Date Based on Today

Anonymous — Sat, 05 Feb 2022 01:54:29 GMT

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!

Re: Conditional Format Overdue Date Based on Today

ValtteriN — Sat, 05 Feb 2022 08:07:40 GMT

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/

Re: Conditional Format Overdue Date Based on Today

Anonymous — Sat, 05 Feb 2022 15:38:37 GMT

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!