Forum Discussion
Dax IF/AND Statement with Null condition
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!
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.
4 Replies
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.
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?
