Last

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

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

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.

Last modified on March 13, 2026