Examples
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 )
Arguments
list1, list2 (Lists of comparable types): the two lists in which to find common elements.
Return Value
List of items common to both list1 and list2.
See Also
ANY(), COUNT(), IN(), LIST(), MAX(), MIN(), SORT(), UNIQUE()