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.