Skip to main content
Version: I2023.2.1

PrevMember

The PrevMember function returns the member that precedes the specified member in the level.

Syntax​

Member_Expression.PrevMember

Return Value​

Returns the previous member value in the level of the specified member.

Input Parameters​

Member_Expression
An MDX expression that returns a member.

Examples​

The following example returns the order quantity for 2006, given the specified member 2007.

SELECT
{
  [Order Date Dimension].[Order Date Month Hierarchy].[Order YearMonth].[2007].PrevMember
} ON 0 ,
{[Measures].[orderquantity1]} on 1
FROM [Internet Sales Cube]