Filter rows in Power Query Editor using another table as a reference

[DebbieE]

If this REFERENCE ID column equals anything in a seperate reference table I have e.g.

Reference Lookup table

TYE

COP

HAE

NOP 

WEP

Then  I filter everything else out

So basically I dont want to hard code these in, I want them to come from this reference table. Is there any way I can do that in the filter or is that outside of what Power BI Can do?

[tex628 · Accepted solution]

Generally speaking i would merge the reference table into the main table and then filter where i don't match. But depending on the size of the main table this might not be the best solution. 

Br,
J

[DebbieE]

It worked Perfectly. Thank you

[DebbieE]

thats something I didnt think of before I can try that