LastSibling (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the last child of the parent of a specified member.

Syntax


Member_Expression.LastSibling   

Arguments

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

Example

The following example returns the default measure for the last day in July 2002.

SELECT [Date].[Fiscal].[Date].&[20020717].LastSibling   
   ON 0  
FROM [Adventure Works]  

See Also

MDX Function Reference (MDX)