List.Distinct
Syntax
List.Distinct(list as list, optional equationCriteria as any) as list
About
Returns a list that contains all the values in list list with duplicates removed. If the list is empty, the result is an empty list.
Example 1
Remove the duplicates from the list {1, 1, 2, 3, 3, 3}.
Usage
List.Distinct({1, 1, 2, 3, 3, 3})
Output
{1, 2, 3}