Repeat the last value of the given column for every row in a column.

Usage

Last(input)

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

Example

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

 

See Also