Forum Discussion

IanCockcroft's avatar
IanCockcroft
Icon for Post Patron rankPost 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
Icon for Community Champion rankCommunity 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
    Icon for Post Patron rankPost Patron
    7 years ago

    Thanks ,worked     it    out