Forum Discussion

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 is populating YES.

Can anyone help me in knowing how to get this?

Thanks

Priyanka

SivaMani
7 years ago
INJAINP,

Try the below DAX code,

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

Thanks,
Siva
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
7 years ago
Hello Angad,

Thanks for your input.

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

Thanks
Priyanka

4 Replies

SivaMani
Resident Rockstar
7 years ago
INJAINP,

Try the below DAX code,

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

Thanks,
Siva
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
  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
    Resident 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

Related content