Forum Discussion
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 like basic functionality, but i cannot get it to work at all. (I Can get it to work on the table view, but I really want this within the query.
Any help will be greatly appreciated as I need this custom column for use elsewhere in the power bi report
hyperbob0811 - You don't use the paren's with if statements in M code. That's DAX syntax.
Should be:
if [alpha_code] = ...
4 Replies
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.
