Forum Discussion
Solved
Nested If formula in Power Bi Query custom column issue
I have the following code in a custom column, and it simply refuses to accept any variant of the very first then string value I want to add. Doesnt matter what I do, I get the same error. this seems...
hyperbob0811 - You don't use the paren's with if statements in M code. That's DAX syntax.
Should be:
if [alpha_code] = ...
hyperbob0811 - You don't use the paren's with if statements in M code. That's DAX syntax.
Should be:
if [alpha_code] = ...
Thanks, now I get a token else error - how do I end this formula?
hyperbob0811 - Add else "" or something like that.
excellent thanks - I was in full DAX and excel mode with the parenthesis and comma's - this seems like you basically right it out as you would say it!
