cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
manikantakommur
New Member

Problem with If statement using blanks

Hello Guys,

I have used this If statement to find loading status, but instead of considering only blanks it is also considering zeros and giving false values. How to solve this  

Loading status =If(('AC'[loading end date]=BLANK()&&'AC'[loading start date]=BLANK()),"Not Loaded", "Loaded")

 

I'd appreciate suggestions on how to deal with this problem.

Thanks,

Manikanta

1 ACCEPTED SOLUTION
arichard19
Resolver I
Resolver I

Trying using the ISBLANK() function (https://docs.microsoft.com/de-de/dax/isblank-function-dax)

For example:
IF( ISBLANK('AC'[loading end date]) &&  ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")
or 
IF( ISBLANK('AC'[loading end date]) || ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")

View solution in original post

1 REPLY 1
arichard19
Resolver I
Resolver I

Trying using the ISBLANK() function (https://docs.microsoft.com/de-de/dax/isblank-function-dax)

For example:
IF( ISBLANK('AC'[loading end date]) &&  ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")
or 
IF( ISBLANK('AC'[loading end date]) || ISBLANK('AC'[loading start date]), "Not Loaded", "Loaded")

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors