PrevMember (MDX)

Returns the previous member from the level members; same as lag(1) or lead(-1).

In our example, we return [Nov 2010].

Query

[Time].[Calendar].[Dec 2010].prevMember

Result

{ 
  [Time].[Calendar].[Month].[Nov 2010]
}

Assertion : MDX Equals

[Time].[Calendar].[Dec 2010].lag(1)

Assertion : MDX Equals

[Time].[Calendar].[Nov 2010]

Returns a NULL member if there is no previous member.

Query

[Geography].[Geo].[Continent].members(0).prevMember

Result

NULL

Using an invalid parameter type causes an error.

Query

{([Geography].[Geo].[United States],[Product].[Licence].[Personal]),([Geography].[Geo].[Spain],[Product].[Licence].[Personal])}.prevMember

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : PrevMember() : argument (0) type mismatch: expected:'member', got:'set'

Using an invalid parameter type causes an error.

Query

{[Geography].[Geo].[United States],[Geography].[Geo].[Switzerland],[Geography].[Geo].[Spain]}.prevMember

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : PrevMember() : argument (0) type mismatch: expected:'member', got:'set'

Using an invalid parameter type causes an error.

Query

([Geography].[Geo].[Spain],[Product].[Licence].[Personal]).prevMember

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : PrevMember() : argument (0) type mismatch: expected:'member', got:'tuple'

Using an invalid parameter type causes an error.

Query

[Geography].[Geo].[Continent].prevMember

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : PrevMember() : argument (0) type mismatch: expected:'member', got:'level'

Using an invalid parameter type causes an error.

Query

"hello".prevMember

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : PrevMember() : argument (0) type mismatch: expected:'member', got:'string'

Returns NULL if applied to a NULL entity.

Query

NULL.prevMember

Result

NULL