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”.
