Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Gaurav_84
Helper I
Helper I

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 filter. Now i want that based on column B i can put all home types under home & Design types under design column.

 

Gaurav_84_1-1649131930206.png

 

Regards

 

4 REPLIES 4
amitchandak
Super User
Super User

@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())

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

Gaurav_84_0-1649134241855.png

 

@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. 

Gaurav_84_0-1649135563939.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.