SWITCH not recognised

[IanCockcroft]

Hi  guys, I have written a formula with a SWITCH to add a custom column.

POWER BI  says it doesnt recognise the SWITCH command.

Why   can I write a formula in    the text box  but  M doesnt recognise  it?

Where should  i write it    then?

very frustrated

Ian

[themistoklis · Accepted solution]

@IanCockcroft

SWITCH is a DAX function and not Power Query Function.... thus you cant use it there

[IanCockcroft]

Thanks ,worked     it    out