Filtering in Power Query

Rudi

New member
Joined
Jan 18, 2014
Messages
134
Reaction score
0
Points
0
Location
Cape Town, RSA
Website
www.eileenslounge.com
Excel Version(s)
Excel 365 ProPlus
Hi,

I have two questions on filtering in Power Query

Question 1:

Is there a way to use the Power Query UI to filter for multiple codes?
Say I want to extract only codes starting with 100- or 150- or 200- from hundreds of codes in a column that look like this (bolded ones to be filtered):
103-98-1234
100-56-4356
106-85-9087
150-98-3245
100-54-9834
108-79-5673

I did it in the 'M' code like this:
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each Text.StartsWith([Ph. Number], "100") or Text.StartsWith([Ph. Number], "150") or Text.StartsWith([Ph. Number], "200") or Text.StartsWith([Ph. Number], "250"))

but just want to know if it is possible using ONLY the UI interface.

Question2:

Is it possible to filter a column of codes in a table that is uploaded into Power Query based on codes in another table?
For example; I have a table of thousands of records with codes similar to the ones in Question #1 above, but I have a second table that contains only the codes I want to use as filters (similar to Excel's Advanced Filter feature). I want to filter in Power Query using a reference to another table that acts as the criteria.

Any ideas/solutions would be great.
TX.

PS: Since Ken is the leading Power Query Guru, I find it strange that his forum does not have a dedicated Power Query section. I had to post these questions in "Other Business Applications". Strange??? (Just commenting
icon11.png
)
 
TX for the reply, Herbds7.
I appreciate your input and time; esp with the sample workbook and screenshot.

Cheers

PS: Does this forum require a "mark as answered" or some other post answer action?
 
With oodles of possibilities, there is never a "right" answer.
 
Back
Top