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.
Hello,
Why am I getting an error with my IF formula on a Query New Column?
=if([Category 1]=" ",[Family 1],[Category 1])
If complaints about the "," but cannot figure out why.
Thank you
J
Solved! Go to Solution.
ok.
"if" needs to be spelled "If"
But am still getting an error saying that
"Expression.Error: The name 'If' wasn't recognized. Make sure it's spelled correctly."
Any reason why?
Did it differently.
Used a Conditional Column. Much easier.
User | Count |
---|---|
79 | |
77 | |
70 | |
68 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |