Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using the SWITCH Command with brackets in the name doesn't work

Hello, I am using the SWITCH command to normalize some company names. For example: Normalized = SWITCH([Company], "International Business Machines", "IBM", "Microsoft", "MSFT"    All is working ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , It should work , check for spaces

 

or try one of the two

 

Normalized = SWITCH([Company],
"Laboratory Corp. of America "(Labcorp")", "LH")

 

or

 

Normalized = SWITCH([Company],
"Laboratory Corp. of America \(Labcorp\)", "LH")

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the quick reply. Okay this is strange, neither work, however:

 

Laboratory Corp. of America "(Labcorp")", "LH") - this errors out the DAX

ERROR: The syntax for '(' is incorrect.

 

Using the backslash doesn't give me an error, but also doesn't change it and it still remains Blank in the filter cards. 

 

However, I don't know if I copied something wrorg or PBI added it but when I add "LH" front the backslash works. For example this works:

 "LH","Laboratory Corp. of America \(Labcorp\)", "LH")

Strange- but thank you!!