Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
Hi, @Thoprice022
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.
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.
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
Hi, @Thoprice022
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.
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
63 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |