Forum Discussion

INJAINP's avatar
INJAINP
Frequent Visitor
7 years ago
Solved

blank value in if else

Hello Folks,   I have below scenario where if date1 is gretaer than date2 then it should display YES And otheriwse it should be  NO.   I want if Date 2 is blank then NO should be populated but it...
  • SivaMani's avatar
    SivaMani
    7 years ago

    INJAINP,

     

    Try the below DAX code,

     

    IF(ISBLANK(date2),"NO", IF(date1 > date2, "YES","NO"))

     

    Thanks,

    Siva

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi INJAINP

     

    Write dax in this way 

    Selection = IF(ISBLANK(Table1[Date2]),"No",
               IF(Table1[Date1]>Test2[Date2],"Yes","No"))

    Hope this will help you!!!

  • INJAINP's avatar
    INJAINP
    7 years ago

    Hello Angad,

     

    Thanks for your input.

     

    The issue got resolved as I was just doing a minor mistake.

     

    Thanks

    Priyanka

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi INJAINP

 

Write dax in this way 

Selection = IF(ISBLANK(Table1[Date2]),"No",
           IF(Table1[Date1]>Test2[Date2],"Yes","No"))

Hope this will help you!!!

INJAINP's avatar
INJAINP
Frequent Visitor
7 years ago

Hello Angad,

 

Thanks for your input.

 

The issue got resolved as I was just doing a minor mistake.

 

Thanks

Priyanka

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    INJAINP

     

    Please post your solution and mark as a solution or mark any of the replies as a solution that solved your problem. It will help people who are facing the same issue.

     

    Thanks,

    Siva