Power Query
Search…
List.IsDistinct

List.IsDistinct

Indicates whether there are duplicates in the list.
function (list as list, optional equationCriteria as nullable any) as logical

Description

Returns a logical value whether there are duplicates in the list list; true if the list is distinct, false if there are duplicate values.

Category

List.Selection

Examples

Find if the list {1, 2, 3} is distinct (i.e. no duplicates).
1
List.IsDistinct({1, 2, 3})
Copied!
true
Find if the list {1, 2, 3, 3} is distinct (i.e. no duplicates).
1
List.IsDistinct({1, 2, 3, 3})
Copied!
false
Last modified 3yr ago