Forum Discussion

lennox25's avatar
lennox25
Icon for Post Patron rankPost 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

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    2 years ago

    lennox25 

     

    Try this

     

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

     

    Phil