Forum Discussion

Isambard's avatar
Isambard
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity 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
    Icon for Helper I rankHelper 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.