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