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]))
nickjordan32's avatar
nickjordan32
Frequent Visitor
6 years ago

I am not an expert on M code but am trying to accomplish the same thing.  Can you please show me with visuals where this code would need to be added?

nickjordan32's avatar
nickjordan32
Frequent Visitor
6 years ago

I got it figured out!! Took me an hour but you gotta learn somehow!  Thanks!