4 METHODS to Filter by a List in Power Query | Excel Off The Grid

Great!!, and the second method makes slower, is it right?

it is easier to follow if you show the right pane always

I have a question and if I need to chain several filters, how would it be?

Amazing 🤩

Another valuable video, thank you very much. We will continue supporting you for your continues support and valuable information.

Somehow, when I attempt the merge it filters out everything in the table that is not in the filter list. Does the list have to contain the exact matches in the table and nothing more? My table is huge.

nice! thank you Sir!

i am in need some help in power query to do following task.can you suggest some solution.
- some rows to be filterout based on some condition(all zero value) in a column
-ranking to be applied in new column based on above filtered column.
-All filtered rows to be restored, so that i will not have any ranking in the filtered rows.

Hey, I would like to filter by the same way but only with part of the text string available in the filter list

List.Contains also plays nicely with query folding...and is executed on the server side for a DB connector.

Excellent video as usual.

Many many thanks for this excellent video: just what i needed!

This tutorial is just perfect. All Your explanations makes sense to me. It’s very clear. Thanks a lot.

Thanks for sharing ❤

Hi Mark,
That's a great explanation.
It is possible to do the same filter when you want to filter records that start only with some chars?.

ex : #"Filtered Rows" = Table.SelectRows(#"Replaced Value1", each Text.StartsWith([Territory], "PT_PH_SM_")),

I have try but only work if I have the complet value.

//#"Filtered Rows" = Table.SelectRows(#"Replaced Value1", each List.Contains(Din_Filter_Territory,[Territory])=true),

Kind regards,
Marco

You always pick worthwhile ideas and, where possible, multiple options to achieve the goal.

When I use that formula for filtering a dataset from a list, it wont recognize [Item] and therefore dont work. But if I use [#"Item"] it works. Do you know why that is?

Great work. Very well explained.

Really interesting - thinking of ways we might use this to streamline our processing ... already worked out the merge approach. Another thought - would be good to adjust the top 3 to top n by passing a number to PQ and using a parameter/variable in the code.