Forum Discussion
Solved
Filter rows in Power Query Editor using another table as a reference
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?
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
3 Replies
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
