Forum Discussion

IanCockcroft's avatar
IanCockcroft
Post Patron
7 years ago
Solved

SWITCH not recognised

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 recogni...
Show and Tell
  • themistoklis's avatar
    themistoklis
    7 years ago

    IanCockcroft

     

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

themistoklis's avatar
themistoklis
Community Champion
7 years ago

IanCockcroft

 

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

IanCockcroft's avatar
IanCockcroft
Post Patron
7 years ago

Thanks ,worked     it    out