Forum Discussion

vagelis's avatar
vagelis
Frequent Visitor
3 years ago
Solved

Custom Column error

I have put together the following custom column in power query editor, and it generates a "Token ',' expected" error on it, and I cant actually see where I have went wrong with the code, show error h...
  • sendilc's avatar
    3 years ago

    Hi, 

     

    I am not sure if PowerQuery supports SWITCH, you will need to used nested if. 

    Alternatively you can use Data view and write a DAX function to insert a new column; the above query should work if replace AND by && , OR by ||

     

    Regards