Token Comma Expected - In Column name?

[nickashwell]

Hi,

I am trying to generate a calculated colomn for reporting purposes and after being pointed towards SWITCH rather than IF functions I am now getting the below error in a custom column?

Clearly there should never be a comma in that name?

Any help would be appreciated

Thanks

[selimovd · Accepted solution]

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 regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Greg_Deckler]

@nickashwell SWITCH is a DAX function, not a power query M function. Unfortunately, there is no case or switch statement in power query.