Forum Discussion
Token Comma Expected - In Column name?
Hey nickashwell ,
it looks like there are two things mixed.
You can add a calculated column in Power BI. There the language is DAX.
Or you can add a column in Power Query. There the language is M.
In your screenshot you add a new column in Power Query, so the language is M. But the SWITCH function is DAX, so it would only work in a calculated column in Power BI.
If you want to add a column in Power Query, you have to use the M language. Sadly M doesn't have a SWITCH function, so you would have to add it as if and else. Check the syntax here:
M Language Conditionals - PowerQuery M | Microsoft Docs
Or as an example for the syntax:
if [my Column] >= 10 and [other Column] <= 100 then "Category 1" else if [my Column] >= 20 and [other Column] <= 200 then "Category 2" else "Category 3"If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Hey nickashwell ,
it looks like there are two things mixed.
You can add a calculated column in Power BI. There the language is DAX.
Or you can add a column in Power Query. There the language is M.
In your screenshot you add a new column in Power Query, so the language is M. But the SWITCH function is DAX, so it would only work in a calculated column in Power BI.
If you want to add a column in Power Query, you have to use the M language. Sadly M doesn't have a SWITCH function, so you would have to add it as if and else. Check the syntax here:
M Language Conditionals - PowerQuery M | Microsoft Docs
Or as an example for the syntax:
if [my Column] >= 10 and [other Column] <= 100
then "Category 1"
else if [my Column] >= 20 and [other Column] <= 200
then "Category 2"
else "Category 3"