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.