All eazyBI for Jira eazyBI for Confluence Private eazyBI

AnyDateInPeriod

EAZYBI Returns true  if any date from a comma-separated string is between the time period's start and end dates. Otherwise, returns false .

Syntax

 AnyDateInPeriod(Dates_String, Time_Member_Expression)

Arguments

Dates_String

String with comma-separated dates (in YYYY-MM-DD or other recognized format).

Time_Member_Expression

MDX expression that returns Time dimension member.

Examples

The following example will be true if any of the issue's previous due dates were in the current Time dimension period. See previous due dates calculated Jira custom field example.

AnyDateInPeriod(
  [Issue].CurrentMember.get('Previous due dates'),
  [Time].CurrentMember
)

The following example will be true if any sprint started in the current Time dimension period. 

AnyDateInPeriod(
  [Measures].[Sprint start dates],
  [Time].CurrentHierarchyMember
)

See the report example Sprint cycles by time in our Demo account. The calculated measure Filter by Sprint Start dates uses the formula above. The report uses this calculated measure as a filter for the report to show only sprint start days.

See also