Forum Discussion
Solved
Filtering table based on another table conditions in Power Query without merging tables
Hi, I'm trying to filter a table based on another table column in Power Query. I do not want to merge the two tables to create a whole new table. Example: I have two separate tables, 1 with the l...
Hi israabuhasna ,
By my tests and research, you could try the power query below.
Table.SelectRows(#"Changed Type", each List.Contains(#"Table 2"[BuildingID],[BuildingID]))
Here is the output.
In addition, you also could download my test file and do a research.
Best Regards,
Cherry
No it won't work because some sources have the same BuildingID and I need to filter only for the source 'S2' since Table2 is only for source S2. Thank you for the response though.
Hi israabuhasna ,
By my tests and research, you could try the power query below.
Table.SelectRows(#"Changed Type", each List.Contains(#"Table 2"[BuildingID],[BuildingID]))
Here is the output.
In addition, you also could download my test file and do a research.
Best Regards,
Cherry