Skip to main content
Version: Next

Lead

The Lead function returns a member that follows the specified member by a specified number of positions in its level.

Syntax​

Member_Expression.Lead(Index)

Return Value​

Returns the member following a specified member by a specified number of positions in the same level.

Input Parameters​

Member_Expression
An MDX expression that returns a member.

Index
A numeric expression that specifies a number of member positions.

Examples​

The following example returns the order quantity for 2016, given the specified member 2013.

SELECT
{
  [Order Date Dimension].[Order Date Month Hierarchy].[Order YearMonth].[2010].Lead(3)
} ON 0 ,
{[Measures].[orderquantity1]} on 1
FROM [Internet Sales Cube]