INTERSECT()

Items common to two lists

Returns a list of items common to two lists.

Sample usage

INTERSECT(LIST("Red", "Blue", "Green"), LIST("Orange", "Blue")) returns a list with one item: Blue. See also: LIST()

INTERSECT(Employees[Name], LIST("Bob")) returns a list of one item, Bob, if that name occurs in the list of employee names. Equivalent to IFS(IN("Bob", Employees[Name], LIST("Bob"))). See also: IFS() , IN()

INTERSECT(Employees[Name], Employees[Name]) returns a list of unique names in the Employees[Name] column. Equivalent to UNIQUE(Employees[Name]). See also: UNIQUE()

Syntax

INTERSECT(list1, list2)

• list1, list2 - Two lists of comparable types in which to find common elements.

See also

ANY()

COUNT()

IN()

LIST()

MAX()

MIN()

SORT()

UNIQUE()