LASTMEMBER

LASTMEMBER

Description:

The function is used to return the last member of the specified level.

Syntax:

Level_Expression.LastMember

Return Type:

MEMBER

Parameters:

Parameter

Description

Parameter

Description

Level_Expression

It is a valid MDX expression that returns a level.

Example:

SELECT [Measures].[Internet Sales Amount] ON COLUMNS, [Date].[Calendar].[Calendar Year].LastMember ON ROWS FROM [AdventureWorksMF_ValueBased]

Copyright Kyvos, Inc. 2026. All rights reserved.