Forum Discussion
Solved
Pass a list as filter argument in Power Query
Hi all, I have a fact table with transactions (sales and product numbers), and a second list of 'required product numbers'. This list is dynamic and can change every time I use the report. I want...
This would be the way:
= Table.SelectRows(factSales, each List.Contains(requiredProductNumbers, [Product]))
Just wondering why you wouldn't use an Inner Join to accomplish this? That seems like the simple way to do it. Do the Inner Join and then delete the column representing the "second list" (which you would convert to a table, either natively in the sheet where it lives or as a quick operation in PQ to convert list to table prior to the join).