UNIQUE()

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.

See also

INTERSECT()

LIST()

SORT()

TOP()

Was this helpful?

How can we improve it?
true