Forum Discussion
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'...
I'd think the best way to filter all reports with the index table would be to set relationships between the tables in power bi then apply a filter to all pages of your report to include all of the index IDs. Would this not work for you?
I note also that you've mentioned you don't want to merge as it will slow things down. I don't think merging will show it down very much. You're not going to be loading any of the index table data onto the other tables - you'll just be merging with it to filter the other tables, after which you can delete the extra column. You could give it a go and see how much it slows things down - I doubt it'll be significant.