Forum Discussion

justin22pogi's avatar
justin22pogi
Regular Visitor
8 years ago

Filter table based on another table

Just want to ask something. I have 2 tables in Powe BI. One contains a data set of 13 million rows and the other table contains one columb with the list of values I want to filter in the main table. I...
justin22pogi's avatar
justin22pogi
Regular Visitor
8 years ago
I'll try doing the calculate table. But why do we need to use EXCEPT?

For the Power Query using Merge as New and Inner Join, do you have a link on the guide on how to donit?

Thanks for the reply?
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Go to  Query Editor - > Select Table 1->Home -> Combine->Merge Queries-> YOur Table1 will appear default, Select Table 2, Select the joining column, Select the join Type as inner join.

 

You should be able to get lots of example in internet. Check the 'Combine Data ' section in this link.  Its just straight forward.

 

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

 

Thanks

Raj