Skip to navigation
Window functions

First

View as Markdown

Usage

First([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 can be different upon refresh if more or different data is available from the cloud data warehouse.

Example

First([Quarter])
  • Returns the first result in the [Quarter] column in every row of the [First] column.

Table with Quarter, First, and Last columns, where First shows Q1 in every row and Last shows Q4 in every row.