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