← Back to List functions

List.Distinct

The list is filtered by eliminating any duplicate entries. A user can input an equation criteria value to determine how to compare the entries for equality. The first entry from each group of equal va...

Syntax

List.Distinct(list as list, optional equationCriteria as any) as list

About

The list is filtered by eliminating any duplicate entries. A user can input an equation criteria value to determine how to compare the entries for equality. The first entry from each group of equal values is selected.

Explanation

Eliminate the duplicate values from the list {1, 1, 2, 3, 3, 3} using the Power Query function MList.Distinct({1, 1, 2, 3, 3, 3}). The resulting output will be {1, 2, 3}.