PREVIOUSVALUE
Calculate a function's result based on the previous row's values
PREVIOUSVALUE( series
, integer
)
Returns the value of a given series or expression from the previous row.
ALIAS of OFFSET
Arguments
Argument | Description |
| Series to return offset row from |
| Optional. Default is -1. Number of rows to offset. |
Output
The value of a series or expression from the previous row or a row offset by a specified number
Example
Last updated