Solved: Conditional Formatting Overdue and blank dates

lennox25 · ‎04-19-2024

Hi,

I have this measure for anything thats overdue past today but need to incorporate blank dates?

Conditional_formatting = if(max(Tablet[ Next Visit]) < Today(),"red")

Thank you

PhilipTreacy · ‎04-19-2024

Try this

Conditional_formatting = if(max(Tablet[ Next Visit]) < Today() || ISBLANK(max(Tablet[ Next Visit])),"red")

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!

View solution in original post

PhilipTreacy · ‎04-19-2024

@lennox25

Try this

Conditional_formatting = if(max(Tablet[ Next Visit]) < Today() || ISBLANK(max(Tablet[ Next Visit])),"red")

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!