Forum Discussion

LYeo87's avatar
LYeo87
Icon for Helper II rankHelper II
5 years ago
Solved

DAX Question - Blank Dates

HI - I am getting this error message:


DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

 

What do I need to do to my expression? I want to know if the date column is blank/empty

 

=IF([Insurance Expiry Date} =" ","Yes","No")
 
 
Thank you in advance. 
Need Help
  • Geradav's avatar
    Geradav
    5 years ago

    LYeo87 Try the following, using ISBLANK()

    IF (
    ISBLANK ( [Insurance Expiry Date],
    "Yes",
    "No"
)

     

2 Replies

  • Geradav's avatar
    Geradav
    Icon for Responsive Resident rankResponsive Resident
    5 years ago

    LYeo87 Try the following, using ISBLANK()

    IF (
    ISBLANK ( [Insurance Expiry Date],
    "Yes",
    "No"
)