All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateBeforePeriodEnd

EAZYBI Returns true  if a date is before the end date of a time period. Otherwise, returns false .

Syntax

DateBeforePeriodEnd(Date_Expression, Time_Member_Expression)

Arguments

Date_ExpressionMDX expression that returns a date that needs to be checked.
Time_Member_ExpressionMDX expression that returns the Time dimension member against which to check.

Examples

The expression below returns the value for issues created before the selected period and resolved after it, in other words, open issues at the chosen period end.

NonZero(
  IIf(
    DateBeforePeriodEnd(
      [Issue].CurrentMember.Get('Created at'),
      [Time].CurrentHierarchyMember
    )
    AND NOT
    DateBeforePeriodEnd(
      [Issue].CurrentMember.Get('Resolved at'),
      [Time].CurrentHierarchyMember
    ),
    (
      [Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]
    ),
    0
  )
)

See sample report Created vs resolved issues over time in our Demo account. Measure Open issues contains the formula above pulling in issues created in the period or in any previous period and not resolved in the period or any previous period. 

See also