Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

Returns the value from a following row at a specified offset after the current row within a partition. Category: window Syntax: 
Lead([column], offset)
Returns: Same as input type Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
columncolumn✓ YesThe column to retrieve the next value from
offsetinteger✗ NoThe number of rows after the current row to retrieve the value from. Defaults to 1.

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

​
Examples

Lead([Sales])
Returns the sales value from the next row (1 row ahead). 
Lead([Price], 3)
Returns the price value from 3 rows after the current row. 
Lead([Revenue], 7)
Returns the revenue from 7 days ahead, useful for forward-looking comparisons.
  • Lag - Returns value from previous row
  • First - Returns first value in partition
  • Last - Returns last value in partition
  • RowNumber - Assigns sequential row numbers
Last modified on March 13, 2026