topic Re: Filter rows in Power Query Editor using another table as a reference in Desktop

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

DebbieE — Tue, 16 Jun 2020 09:52:32 GMT

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?

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

tex628 — Tue, 16 Jun 2020 10:00:16 GMT

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

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

DebbieE — Tue, 16 Jun 2020 10:19:03 GMT

thats something I didnt think of before I can try that

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

DebbieE — Tue, 16 Jun 2020 10:28:27 GMT

It worked Perfectly. Thank you