Skip to main content
Returns the last value in the current partition or window, regardless of the current row’s position. Category: window Syntax: 
Last([column])
Returns: Same as input type Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column to retrieve the last value from

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

​
Examples

Last([Sales])
Returns the sales value from the last row in the partition. 
Last([Closing_Price])
Returns the closing price from the last day in the partition, useful for comparing current values to final values. 
Last([Customer_Name])
Returns the last customer name in the ordered partition.
  • First - Returns first 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