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
v-zhangti
Community Support
Community SupportHi, 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.