OFFSETBY
Offsets values within a column, partitioned by the unique values of a separate column
OFFSETBY( offset column
, number of rows
, partition column
, sort column
)
Returns a reference to a row relative to the current row, determined by the input number of rows
. The offset is partitioned by a given column, or set of columns, and the offset calculation is determined by a sort parameter optionally provided.
OFFSETBY() is a window function, which performs like OFFSET() except partitioned by the unique values of a different column.
Arguments
Output
Offset value
Example
Last updated