List.Distinct
ListReturns a list with duplicate values removed.
Syntax
List.Distinct(list as list, optional equationCriteria as any) as listParameters
| Name | Type | Required | Description |
|---|---|---|---|
list | list | Yes | The list to deduplicate. |
equationCriteria | any | No | A comparer function for custom equality testing. |
Return Value
list — A list containing only unique values, preserving the order of first occurrence.
Remarks
List.Distinct removes duplicate values from a list, keeping the first occurrence of each unique value. Use a comparer function like Comparer.OrdinalIgnoreCase for case-insensitive deduplication.
Examples
Example 1: Get unique product categories
let
Categories = List.Distinct(Table.Column(Sales, "Category"))
in
#table({"Category"}, List.Transform(Categories, each {_}))Result
Category | |
|---|---|
| 1 | Widgets |
| 2 | Gadgets |
| 3 | Misc |
Compatibility
✓ Power BI Desktop✓ Power BI Service✓ Excel Desktop✓ Excel Online✓ Dataflows✓ Fabric Notebooks