Forum Discussion
Filtering Long Table Based on Another Table
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...
On your first table, in the formula bar, type:
= Table.SelectRows(Source, each List.Contains(List.Distinct(Table2[Name]), [Name]))
--Nate
On your first table, in the formula bar, type:
= Table.SelectRows(Source, each List.Contains(List.Distinct(Table2[Name]), [Name]))
--Nate
That was quick, thanks a million