Forum Discussion

JuanSombrero's avatar
JuanSombrero
Frequent Visitor
9 years ago
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...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    This would be the way:

     

    = Table.SelectRows(factSales, each List.Contains(requiredProductNumbers, [Product]))
Deano777's avatar
Deano777
New Member
3 years ago

I still get no results on this

prafael's avatar
prafael
Frequent Visitor
3 years ago

For the colleague's code to work you need to convert the table with the values to be filtered to a list or replace requiredProductNumbers with a list, for example, {"Product1", "Product2", "Product3",...,"Productn"}