First

Returns the first value in the current partition or window, regardless of the current row’s position. Category: window Syntax:

First([column])

Returns: Same as input type Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`column`	`column`	✓ Yes	The column to retrieve the first value from

First([Sales])

Returns the sales value from the first row in the partition.

First([Opening_Price])

Returns the opening price from the first day in the partition, useful for comparing current values to initial values.

First([Customer_Name])

Returns the first customer name in the ordered partition.

Last modified on March 6, 2026