FIRSTBY

Finds the first element within a column, partitioned by the unique values of a separate column

FIRSTBY(column, partition column)

Returns the first element within a column when grouped by unique values within a partition column

Arguments

Argument

Description

column

Column of any type

partition column

Column containing unique values

Outputs

Outputs column of values corresponding to the first value within partitioned groups

Example

Last updated