Forum Discussion

Isambard's avatar
Isambard
Helper I
2 years ago

Filter table by another table in power query

I have several tables each with [Index ID] as a collumn. I also have one table 'Index' which is just a list of valid IDs. I want to filter all my other tables to include only the IDs from the 'Index'...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi Isambard, why don't you want to use Merge? It is fast solution. Just merge your tables based on Index value and then use filter.

Isambard's avatar
Isambard
Helper I
2 years ago

I've always assume dit would slow things down, basically loading in the same data twice. Is this not the case?

 

Thank you.