Forum Discussion
How To Pass a List through Filter in Power Query Editor?
Hi, I've got a list of agent numbers in one list, e.g. 0001, 0002, 0003, 0004. Basically, I want to (in Advanced Editor/Query Editor) use an IF statement to force an output if the agent number matc...
Hi Anonymous
Please see the attached file with a solution
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks so much! For the benefit of others, the format ends up being as follows:
List.Contains( IncentivisedAgents[Agent ID], [Agent ID] )Where "IncentivisedAgents" is the name of the definer table with the list, the first "[Agent ID]" is the name of the column within the definer table, and the second "[Agent ID]" is the name of the column within your current table/query (or fact table) containing the agent numbers you want looked up.
The "Table.SelectRows" that I was trying to incorporate is actually a filter function within the Query Editor that physically filters out entries/rows that don't match, which is not what I was trying to achieve.