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 basic...
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
