blank value in if else

[INJAINP]

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 · Accepted solution]

@INJAINP,

Try the below DAX code,

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

Thanks,

Siva

[Anonymous · Accepted solution]

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!!!

[Anonymous · Accepted solution]

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 · Accepted solution]

Hello Angad,

Thanks for your input.

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

Thanks

Priyanka

[SivaMani]

@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

[SivaMani · Accepted solution]

@INJAINP,

Try the below DAX code,

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

Thanks,

Siva