topic Re: How to use CONTAINSTRING inside SWITCH? in DAX Commands and Tips

How to use CONTAINSTRING inside SWITCH?

matheus_peppers — Tue, 27 Sep 2022 17:19:26 GMT

Hello everybody, how are you?

I need your help urgently for a problem I'm having.

I have a column with different values, but with a specific string that repeats in more than one row.

What do I need to do?

I need to categorize these specific strings into 3 different categories, which are the regions that each location equals.

I am trying to use SWITCH with CONTAINSSTRING, because I need it to return the text I want in the calculated column if it finds the text I am looking for.

But it is not working. Can anyone help me and tell me where I am going wrong, or any alternative way for me to get what I want?

Re: How to use CONTAINSTRING inside SWITCH?

amitchandak — Wed, 28 Sep 2022 02:02:54 GMT

matheus_peppers , You should use Switch (True(),

and then you can check for true in each expression

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

Re: How to use CONTAINSTRING inside SWITCH?

Anonymous — Wed, 28 Sep 2022 04:59:03 GMT

Hi matheus_peppers ,

Here are the steps you can follow：

1. Create calculated column.

Column = SWITCH( TRUE(), CONTAINSSTRING('Table'[Anuncio],"Taubate")=TRUE(),"Taubate", CONTAINSSTRING('Table'[Anuncio],"Canas")=TRUE(),"Canas")

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly