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_Expression	MDX expression that returns a date that needs to be checked.
Time_Member_Expression	MDX expression that returns the Time dimension member against which to check.

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.