First

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

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us