Skip to content

Instantly share code, notes, and snippets.

@CurtHagenlocher
Created May 14, 2015 21:00
Show Gist options
  • Save CurtHagenlocher/ae1cbf55b2a7e138a37c to your computer and use it in GitHub Desktop.
Save CurtHagenlocher/ae1cbf55b2a7e138a37c to your computer and use it in GitHub Desktop.
Filter by values from another table
let
data = Table.FromColumns({{1, 2, 3, 4, 5}, {"Left", "Right", "Center", "Left", "Right"}}),
filter = Table.FromColumns({{"Right", "Center"}}),
filterValues = filter[Column1],
filtered = Table.SelectRows(data, each List.Contains(filterValues, [Column2]))
in
filtered
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment