All eazyBI for Jira eazyBI for Confluence Private eazyBI

PrevMember

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

Syntax

 Member_Expression.PrevMember

Arguments

Member_ExpressionMDX expression that returns a member.

Examples

The following example returns a previous month. 

[Time].[Month].CurrentDateMember.PrevMember

See report example Kanban project overview in our Demo account. The default calculated member Previous month in dimension Time uses the formula above.  The report uses this calculated member and several others calculated members in Time dimensions as a selection option on Pages.

Members of the Time dimension are created dynamically only for dates that have some data. For example, if the current month is January and previous data is saved only in October, [Time].[Month].CurrentDateMember.PrevMember will return October. eazyBI imports date members if there is any activity per date. Add members to date range if you have missing periods in eazyBI.

See also