First

Usage

First([column])

Function Arguments:

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

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.