Repeats the first row value of the given column for every row in the output column.

Usage

First(field)

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

Example

First([Quarter])
  • If Quarter has “Q1”, “Q2”, “Q3” and “Q4”, the result would be “Q1”, “Q1”, “Q1” and “Q1”.

See Also