List.Intersect

Syntax

List.Intersect(lists as list, optional equationCriteria as any) as list

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

Find the intersection of the lists {1..5}, {2..6}, {3..7}.

Usage

Power Query M

List.Intersect({{1..5}, {2..6}, {3..7}})

Output

{3, 4, 5}