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. 

The following formula can be used for a custom measure in the Measures dimension to find the Hours spent in a specific period.

Aggregate(
  [Time].[Day].DateMembersBetween("Jan 01 2024", "Jan 31 2024"),
  [Measures].[Hours spent]
)

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.