Forum Discussion
Filter column
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 filt...
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.
Thanks Amit, I got bit confused can you please explain the query you have written with below data example.