Returns the last row value in a column.

Usage

Last(\[Column\])

Function Arguments:

  • field (required) A column of text, numbers, or dates to analyze.

🚧

When there is no sort specified to the table, the results for this function can change when refreshing the workbook, as the sort will be different upon refresh.

Example

Last(\[Quarter\])

Returns the last result in the [Quarter] column in every row of the [Last] column.


Related resources