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