Returns the previous member in the level that contains a specified member.

Syntax

Member_Expression.PrevMember
CODE

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

Following example returns previous month. 

[Time].[Month].CurrentDateMember.PrevMember
CODE

Members of Time dimension are created dynamically only for dates that have some data. For example if current month is January and previous data is saved only in October, [Time].[Month].CurrentDateMember.PrevMember will return October.

See also