Forum Discussion

lennox25's avatar
lennox25
Post Patron
2 years ago
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
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    2 years ago

    lennox25 

     

    Try this

     

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

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
2 years ago

lennox25 

 

Try this

 

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

 

Phil