DateBeforePeriodEnd

EAZYBI Returns if a date is before a time period end date.

Syntax

 DateBeforePeriodEnd(date, Time_Member_Expression)

Arguments

date	Date expression.
Time_Member_Expression	MDX expression that returns Time dimension member.

Examples

  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.