All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateMembersBetween

EAZYBI Returns a set of Time dimension hierarchy level members between two specified dates.

Syntax

Time_Level_Expression.DateMembersBetween(From_Date_Expression, To_Date_Expression)

Arguments

Time_Level_Expression

MDX expression that returns Time dimension hierarchy level.

From_Date_Expression

Date expression that returns the period start date (included).

To_Date_Expression

Date expression that returns the period end date (included).

For Date expressions, you can also use a string expression that can be parsed with DateParse or relative dates.

Examples

The following formula will pull in Time dimension Month level members that represent the last 12 months, including the current month.

Aggregate(
  [Time].[Month].DateMembersBetween('12 months ago', 'today')
)

See the sample report Created vs resolved issues over time in our demo account. The default calculated member Last 12 months uses the formula above to show past rolling 12 month from today. You can see more examples of Time calculated members in our demo account. 

Note: To retrieve all date members between two given dates, they should be imported in the Time dimension. For future periods, it is advised to add missing Time dimension members.