DateInPeriod
EAZYBI Returns if date is between time period start and end dates.
Syntax
DateInPeriod(date, Time_Member_Expression)
Arguments
date | Date expression. |
|---|---|
Time_Member_Expression | MDX expression that returns Time dimension member. |
Examples
The following example works as a filter and will give value true if an issue is created and resolved in a selected period.
DateInPeriod( [Measures].[Issue created date], [Time].CurrentHierarchyMember) AND DateInPeriod( [Measures].[Issue resolution date], [Time].CurrentHierarchyMember)
See example report Issues created and resolved in period % in our demo account. The calculated measure Issues created and resolved in period uses the formula above to count resolved issues that was created in the same period on a timeline.