List.Intersect

This function identifies and retrieves the common values present in multiple lists provided as input. Users have the option to include an additional parameter, equationCriteria, to further customize t...

Syntax

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

About

This function identifies and retrieves the common values present in multiple lists provided as input. Users have the option to include an additional parameter, equationCriteria, to further customize the search.

Explanation

Determine the common values in the sets {1 to 5}, {2 to 6}, {3 to 7}. Apply the Power Query MList.Intersect function with the lists {{1 to 5}, {2 to 6}, {3 to 7}} to find the intersection.Output: {3, 4, 5}