Ndv

The Ndv function returns the number of unique values within a column or group. This is an alias of the CountDistinct function and works similarly.

Syntax

Ndv(column)

Function arguments:

• column (required) - The column of values to be counted. Duplicate and Null or empty values are not counted.

Example

Ndv(\[City\])

• Finds the number of unique city names.