Forum Discussion
vagelis
3 years agoFrequent Visitor
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...
- 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
sendilc
3 years agoFrequent Visitor
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