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...
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.
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
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?