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]))
Rygaard's avatar
Rygaard
Resolver I
5 years ago

This dont work - Because people have imported their table as a table and not as a list.

if you "table" do not have a "list" icon.. it wont work.

 

so the "list" of parameterse is a table when you import it - but you can easy chang this

 

  1. click the table you want to use a list
  2. click Transform tab (next to home)
  3. select convert to list

NOW you can use it  as a list

 

 

= Table.SelectRows(#"Omdøbte kolonner", each List.Contains(Tabel4,[Vejesag]))

 

 

 

 

 

DamianM's avatar
DamianM
Frequent Visitor
1 year ago

Rather than adding an additional step to transform the table to a list, simple add the column name of the table to the end of the step
From:
= Excel.CurrentWorkbook(){[Name="yourTable"]}[Content]
To:
= Excel.CurrentWorkbook(){[Name="yourTable"]}[Content][yourListColumn]