Nested If formula in Power Bi Query custom column issue

[hyperbob0811]

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

[Greg_Deckler · Accepted solution]

@hyperbob0811 - You don't use the paren's with if statements in M code. That's DAX syntax.

Should be:

if [alpha_code] = ...

[hyperbob0811]

Thanks, now I get a token else error - how do I end this formula?

[Greg_Deckler]

@hyperbob0811 - Add else "" or something like that.

[hyperbob0811]

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!