List.IsDistinct

This function determines if the list contains any duplicate values. It returns "true" if all values in the list are unique, and "false" if there are any duplicates.

Syntax

List.IsDistinct(list as list, optional equationCriteria as any) as logical

About

This function determines if the list contains any duplicate values. It returns "true" if all values in the list are unique, and "false" if there are any duplicates.

Explanation

Determine whether a list {1, 2, 3} contains any duplicate values. Usage: Power Query MList.IsDistinct({1, 2, 3}) Output: true Identify if the list {1, 2, 3, 3} has any duplicate values. Usage: Power Query MList.IsDistinct({1, 2, 3, 3}) Output: false