List.IsDistinct
This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.
Returns whether a list is distinct.
List.IsDistinct(list as list, optional equationCriteria as any) as logical
| Argument | Description |
|---|---|
| list | The List to check. |
| optional equationCriteria | Equation criteria value used to control equality comparison. For more information about equationCriteria, see Parameter Values. |
List.IsDistinct({1, 2, 3, 2, 3}) equals false
List.IsDistinct({"a","b","A"}, Comparer.FromCulture("en",false) equals true
List.IsDistinct({"a","b","A"}, Comparer.FromCulture("en",true) equals false
Show: