Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper V
7 years ago
Solved

Rewrite IF function

Hi all, I’m currently struggling to rewrite this excel formula to DAX. Excel formula IFERROR( IF(A2-B2 >= -1, “Yes”, IF ( B2 = “ “, “No”, “No”)), “No”) I’ve tried to write in DAX, but I’m gettin...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Perhaps

     

    IF(  Table1[Date1] - Table1[Date2] < -1 || ISBLANK(Table1[Date2]), "No", "Yes")

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

Stuznet

 

Are you sure it is blank and not just an empty cell?

 

Maybe the following?

 

IFERROR(IF((Table1[Date1] - Table1[Date2]) >= -1, "Yes",
IF(OR(Table1[Date2] = BLANK(), Table1[Date2]="", LEN(Table1[Date2]) = 0), "No","No")),"No")