Forum Discussion
Solved
Filter data based on list from another worksheet
Hi I have a worksheet "A" which contains extracted data using Power Query. The data has 5000 lines which I want to filter down to just 60 lines using data extracted from another worksheet "B". ...
Hi,
you can try this 2 options
- with merge (RightOuter)
- with List.Contains
adding a custom column
= Table.SelectRows( Table.AddColumn(Source, "Custom", each List.Contains(B[Code], _[Code])), each [Custom]=true)
You can see it in the attached file
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
Hi,
you can try this 2 options
- with merge (RightOuter)
- with List.Contains
adding a custom column
= Table.SelectRows( Table.AddColumn(Source, "Custom", each List.Contains(B[Code], _[Code])), each [Custom]=true)
You can see it in the attached file
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
