Skip to main content
Skip table of contents

PrevMember

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

Syntax

CODE 
Member_Expression.PrevMember

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

Following example returns previous month. 

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

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.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close