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]))
Hello--sorry I missed this somehow--happy to oblige though!! Here is a code snippett below which should give you what you want:
//
//Use the parameter list to feed code values...
//
tblIncludeStates = Table.SelectRows(tblFromDownload, each List.ContainsAny({MyCodeList} ,{[Outstate_Code]})),
..the "MyCodeList" is my list of codes..the "ContainsAny" is the m function/method that did the trick for me..you might also look at the type you used for the list and make sure it coincides with the type you are looking to iterate over.
Hi! Can I do that with query folding on Oracle DB?