Filtering Long Table Based on Another Table

[Anonymous]

Hi Guys, how is everything?

I need some help here please. I need to filter a column in a table, long one actually (the first image is a sample of it), to keep only the mentioned names in a column in another table (the second image), to reach the outcome illustrated in the final image (the third image), how could I do that?

I think this is reachable thru the "List" concept but I am not pretty sure about the needed script to write, could you help please?

[Anonymous · Accepted solution]

On your first table, in the formula bar, type:

= Table.SelectRows(Source, each List.Contains(List.Distinct(Table2[Name]), [Name]))

--Nate

[Anonymous]

I'm sorry for the bothering again.

I've tried to play with the given script a bit and I've applied this:

= Table.SelectRows(#"Changed Type", each List.Contains(List.Distinct(#"Removed Other Columns2"), [Agent]))

Simply, I'm trying to filter a query table using the same query table at different step, isn't this techinically allowed logically speaking? Yet, I'm getting this error:

Expression.Error: We cannot convert a value of type Table to type List.
Details:
Value=[Table]
Type=[Type]

[Anonymous]

That was quick, thanks a million