Power Query
published
Search
⌃K

List.Intersect

List.Intersect

Returns the intersection of the list values found in the input.
function (lists as list, optional equationCriteria as nullable any) as list

Description

Returns the intersection of the list values found in the input list lists. An optional parameter, equationCriteria, can be specifed.

Category

List.Set operations

Examples

Find the intersection of the lists {1..5}, {2..6}, {3..7}.
List.Intersect({ {1..5}, {2..6}, {3..7} })
{3, 4, 5}