Forum Discussion
Solved
Conditional Formatting Overdue and blank dates
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
Try this
Conditional_formatting = if(max(Tablet[ Next Visit]) < Today() || ISBLANK(max(Tablet[ Next Visit])),"red")Phil
1 Reply
Try this
Conditional_formatting = if(max(Tablet[ Next Visit]) < Today() || ISBLANK(max(Tablet[ Next Visit])),"red")Phil