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
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ，

I tried the dax you provided and it works.See the below:

 

Check that the contents of the table match exactly what is used in Dax. And could pls provide your pbix file ? Remember to remove the confidential information.

 

Wish  it is helpful for you!

 

Best Regard

Lucien Wang