Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Community, I ran into a strange mistake here:
I accidentally discoved that when I use
IF([Column]=BLANK(), "TRUE", "FALSE")
the returned value is different from
ISBLANK([Column])
Dose anyone have any idea why would it be the case?
Codes:
Solved! Go to Solution.
@Cynwaa ,
No, IF() function works well, because "0 = BLANK()" will always return bool value "TRUE".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Cynwaa ,
Could you share the sample data of report table?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yuta-msft , thanks for your reply!
below are links for the sample data.
Power BI file: https://www.dropbox.com/s/uj9my9xiewiswdh/Test.pbix?dl=0
Source data in excel: https://www.dropbox.com/s/hgm837seq3ll7wo/Test.xlsx?dl=0
@Cynwaa ,
Sorry for late, there's some difference between these two functions, if you change one "0" to "NULL" or nothing, ISBLANK() can work. But if the value is "0", ISBLANK will recognize it as a number "0".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yuta-msft thanks a lot for your reply.
I think the ISBLANK() function is always working alright, but my question is rather: why doesn' t the IF function work?
IF([Column]=BLANK(), "TRUE", "FALSE")
@Cynwaa ,
No, IF() function works well, because "0 = BLANK()" will always return bool value "TRUE".
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ah ok ... thanks a lot for this answer, I think that's the problem.
But why 0=BLANK() is true? That is not so intuitively understandable..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |