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.
I need help with the if condition. The third condition is not being applied where i am using and condition together with if.Can anyone please tell me the issue here?
Solved! Go to Solution.
Hi @Anonymous
You could add a pair of parentheses to wrap the third condition in this if statement. This should work.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
we can't see your data so can't give you an exact answer but you can debug it from your side.
Remove all the other 'if' tests so that you only have the line with the 'and's (put a simple string in the 'else').
Now, copy the line somewhere else (text editor or something - just so you don't lose it)
Remove all the 'and' conditions to make the 'if' conditions work. Then add 1 'and' condition back in. See if it breaks. When it works, add another 'and' condition in, then repeat etc.
This is the data i have circled the values as well.
Hi @Anonymous
You could add a pair of parentheses to wrap the third condition in this if statement. This should work.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.