Filter column

[Gaurav_84]

Hi All,

Need you expert advice i want to create 2 columns within table using filter function. Below is how my data look.

Column A include both home & design types & column B can be used for filter. Now i want that based on column B i can put all home types under home & Design types under design column.

Regards

[amitchandak]

@Gaurav_84 , new columns 

Column B  = Switch( True() ,

search("Home",[ColumnA],,0) > 0 , "Home ",

search("Design",[ColumnA],,0) > 0 , "Design", Blank() )

Home = if([Column b] ="Home", "Home", blank())

Design= if([Column b] ="Design", "Home", blank())

[Gaurav_84]

Hi Amit, Thanks for your response, i believe i have given the incorrect example. Right example should be like below one.

[amitchandak]

@Gaurav_84 , I think First switch has to change

example

Column B = Switch( True() ,

[Column A] in {"Value1", "Value2", "ABC",

//add others

search("Design",[ColumnA],,0) > 0 , "Design", Blank() )

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Gaurav_84]

Thanks Amit, I got bit confused can you please explain the query you have written with below data example.