Filter column values in Table 1 which the same value exists in a column Table 2 and Table 3

Question

Hello all!&nbsp;Is there a way to filter column values in Table 1 if only the values exists in&nbsp;a column in the Table 2 and Table 3?

jbwtp · Accepted Answer

Hi&nbsp;ti-fpe,&nbsp;yes, something like this:let 
    t1 = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJSitWJVnICskzALGcgy0wpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Team = _t, Numbers = _t]),
    t2 =  Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTJSitWBsIzhLBM4yxTMcgKyDOAsCywsS6XYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Team = _t, Small = _t]),
    Custom1 = Table.SelectRows(t2, each List.Contains(t1[Numbers], [Small]))
in
    Custom1&nbsp;Cheers,John

Forum Discussion

Filter column values in Table 1 which the same value exists in a column Table 2 and Table 3

1 Reply

Related content

Filter a column with duplicate values based on the highest Index value

Splitting Column values

Slicer for filtering several columns

find max value based on another filtered column

Matching Column Values