Dax IF/AND Statement with Null condition

[Anonymous]

Hi all,

I have to create an IF/AND statement with a null condition 

My condition is as follows:

Quality = 

IF(NOT(ISBLANK([Version])) && ISBLANK([Date])),

"Yes",

"No")

The logic is if Version is null and Date is not null then it outputs "Yes", otherwise "No".

I'm not getting an output and think something is wrong with the coding.

I am fairly new to Power BI and DAX so any resources to study is greatly appreciated.

Thank you!

[erothen]

Do you have any examples of input and output data?

Remark from https://docs.microsoft.com/en-us/dax/blank-function-dax

• Some DAX functions treat blank cells somewhat differently from Microsoft Excel. Blanks and empty strings ("") are not always equivalent, but some operations may treat them as such.

[Anonymous]

Input

Version	Date
A	9.12
A
	9.10
B	9.12

Output

Version	Date	Quality
A	9.12	No
A		Yes
	9.10	No
B	9.12	No
		No

They are blank and not empty strings.

Please let me know if you need anymore clarity

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Quality = 
IF([Version]=BLANK()&&[Date]<>BLANK(),
"Yes",
"No")

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[erothen]

When recreating in my own PBI, I noticed your provided DAX statement has an extra parenthesis after ISBLANK([Date]), so you could try the fixed version below:

Quality = IF(NOT(ISBLANK([Version])) && ISBLANK([Date]), "Yes", "No")

If this doesn't fix things, can you let me know if there is an error (and if so, what does it say), or does the quality column just come up as blank? Also, what data type are you using for date?