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

Argument	Description
offset column	Column to return.
number of rows	Number of rows to offset. number of rows can be positive or negative.
partition column	A column, or set of columns, to partition the ranking by.
sort column	Optional, defaults to offset column . Sort value to use when determining the offset value.

Output

Offset value

Example