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.
Hey, guys,
I have a problem with ISBLANK. I am usinng it in formula like this:
What is going on here?
I am attaching a link to an example file: https://www.dropbox.com/s/vwt3r1xf6ak2fp5/Example2.pbix?dl=0
Thankfull for any help.
Solved! Go to Solution.
You are missing the ELSE option in your IF() expression and if you do not specify this the default behaviour is to return a blank value.
So the logic basically says "IF the calculation is blank return 0 else return blank"
You could fix this by repeating your calculate expression, but I would fix this by capturing the result of that expression in a variable and then return that value.
eg
You are missing the ELSE option in your IF() expression and if you do not specify this the default behaviour is to return a blank value.
So the logic basically says "IF the calculation is blank return 0 else return blank"
You could fix this by repeating your calculate expression, but I would fix this by capturing the result of that expression in a variable and then return that value.
eg
User | Count |
---|---|
78 | |
75 | |
62 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |