Lead
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
