Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DATE/VALUE error with IF & OR statement

Hi everyone,   I have an IF & OR statement te syntax is below and I am getting the following error "DAX comparison operations do not support comparing values of type Date with values of type Text. ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please try this...

     

    Result = IF(IFERROR(SEARCH("/",Test59StrDate[Enrollment],4),0)>0,IF(VALUE(FORMAT(Test59StrDate[Enrollment],"Short Date"))>=Test59StrDate[Outreach],"Yes","No"),"No")

petrovnikitamai's avatar
petrovnikitamai
Resolver V
7 years ago

i'm not sure but try this

new column = 
IF([Date of student enrollment ]=BLANK()  ||  
    [Date of student enrollment]="NULL" ||  
    [Date of student enrollment ]="-"   ||  
    [Date of student enrollment] || 
    [Date of student enrollment]="na","No",
IF(DATEVALUE([Date of student enrollment ])>=DATEVALUE([Date of student outreach]),"Yes","No"))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Unfortunately, that still came up with an error