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 

     

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

 

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

pagliaci