All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateAfterPeriodEnd

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

Syntax

 DateAfterPeriodEnd(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

This example formula will show true if issue due date is in the future (after) of a selected period:

DateAfterPeriodEnd(
  [Measures].[Issue due date],
  [Time].CurrentHierarchyMember
) 

The example formula below will show true if the selected period (timeline) is in past of Today, Today is after the selected period

DateAfterPeriodEnd(
  'Today',
  [Time].CurrentHierarchyMember
)

See example report Version report in our demo account.  The formula above is used as a filter in the calculated measure Cumulative Story Points resolved till today. The formula will show cumulative resolved Story Points for past periods only.