DateInPeriod
EAZYBI Returns true if a date is between the time period start and end dates. Otherwise, returns false .
Syntax
DateInPeriod(Date_Expression, Time_Member_Expression)
Arguments
Date_Expression | MDX expression that returns a date that needs to be checked. |
|---|---|
Time_Member_Expression | MDX expression that returns the Time dimension member against which to check. |
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 the 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 were created in the same period on a timeline.