Skip to main content
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

NameTypeRequiredDescription
columncolumn✓ YesThe column to retrieve the first value from

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

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 - Returns last value in partition
  • Lag - Returns value from previous row
  • Lead - Returns value from following row
  • RowNumber - Assigns sequential row numbers
Last modified on March 13, 2026