Forum Discussion
Conditional Format Overdue Date Based on Today
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...
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/
Hi,
You can create a measure like this:
DateFormatMeasure = IF(MAX(DateFormat[Date])>TODAY(),1,0)
Then go here:
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/
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!