All eazyBI for Jira eazyBI for Confluence Private eazyBI

DateAfterPeriodEnd

EAZYBI Returns if date is after time period end date.

Syntax

 DateAfterPeriodEnd(Date, Time_Member_Expression)

Arguments

DateDate expression.
Time_Member_ExpressionMDX expression that returns Time dimension member.

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.