Expression.Error: The name 'SWITCH' wasn't recognized. Make sure it's spelled correctly.

[Sathvik123]

Hello All,

I am creating a custom column and I am not getting any syntax errors but when I click ok I am getting below error.

Could any one please help how to fix this

[Ashish_Mathur · Accepted solution]

Hi,

Switch is a DAX function not an M function?  Write it as a calculated column formula

=if(and([Region="APAC",OR([AgentDepartment]="Hyd",[AgentDepartment]="Unknown")),"ASD Hyd",blank())

Hope this helps.

[Sathvik123]

Hi @Ashish_Mathur ,

I am getting below error.

[Ashish_Mathur]

Write a calculated column formula in DAX not a Custom formula in M

[Sathvik123]

Hi @Ashish_Mathur ,

Could you please help how to do dax for this.

Here my region is a table created in power bi

[Ashish_Mathur]

Already shared that.