Unique items in list
Returns a list of items in the original order with duplicates removed.
UNIQUE()
is case-insensitive. That is, abc
and ABC
are treated as the same value.Sample usage
UNIQUE(LIST(1, 1, 2, 1, 3))
returns 1
, 2
, 3
UNIQUE(LIST("Mary", "David", "Joe", "David"))
returns Mary
, David
, Joe
UNIQUE(Products[Color])
returns a list of Color
column values from the Products
table without duplicates.
Syntax
UNIQUE(list)
list
- A list of any type.