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.