Forum Discussion

pagliaci's avatar
pagliaci
Frequent Visitor
4 years ago
Solved

Create column with the group for multiple values

Hello, I have a Table with a column called "Names" with a lot of versions of 2 products for example "barbie" and "cars". I need to create a new column "Groups" that show me only the major groups, but...
  • smpa01's avatar
    smpa01
    4 years ago

     

    column = switch(true(),CONTAINSSTRING('tbl'[Names],"Barbie")=TRUE(),"Barbie","Cars")

    pagliaci 

     

pagliaci's avatar
pagliaci
Frequent Visitor
4 years ago

What if I have more than 1 option, I wanted to say if glow OR beach than write Barbie. How do I make this OR?

I am trying || : 

column = switch(true(),CONTAINSSTRING('Versões - SAP'[Versões],"CONCENTRADO" || "CONCENT")=TRUE(),"CONCENTRADO")
 
but it gives me the error Cannot convert value 'CONCENTRADO' of type Text to type True/False.
smpa01's avatar
smpa01
Community Champion
4 years ago

pagliaci 

 

column = switch(true(),CONTAINSSTRING('tbl'[Names],"Barbie")=TRUE()||CONTAINSSTRING('tbl'[Names],"Glow")=TRUE(),"Barbie","Cars")