Shift a column upward.

Usage

Lead(field, offset, default)

field (required) A column of values to be shifted.

offset (optional) Distance, in rows, to shift. Must be an integer greater than 0. Defaults to 1 if an offset value isn’t provided.

default (optional) Default value for the first offset rows. Rows will be Null if a default isn’t provided.

Example

Lead([Quarter], 1)
  • If Quarter has”Q1″, “Q2”, “Q3″ and”Q4″, the Lead of 1 would be”Q2”, “Q3”, “Q4” and Null

See Also


Was this page helpful?
Yes No