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]))
dslForPBI's avatar
dslForPBI
Icon for Helper I rankHelper I
8 years ago

Not sure how this is the correct answer.  Executing this results in:

 

Expression.Error: We cannot convert a value of type List to type Table.
Details:
Value=List
Type=Type

 

I tried doing the same thing and it produces as I have a list I am using to try and filter a table in the same way.  Other examples mention trying to using a query parameter instead--seems like it is much more laborious than it should be.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Having the same issue here, have been trying to figure this out all morning.

No luck! If someone could elaborate futher it would be appreciated greatly.