AnyDateInPeriod
EAZYBI Returns if any date from comma separated string is between time period start and end dates.
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
AnyDateInPeriod([Issue].CurrentMember.get('Previous due dates'), [Time].CurrentMember) will be true if any issue previous due date was in current Time dimension period. See previous due dates calculated Jira custom field example.
The following example will be true if any sprint started in the current Time dimension period.
AnyDateInPeriod( [Measures].[Sprint start dates], [Time].CurrentHierarchyMember )
See 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.