Returns if a date is before a time period end date.
Syntax
DateBeforePeriodEnd(date, Time_Member_Expression)
Arguments
| date | Date expression. |
|---|---|
| Time_Member_Expression | MDX expression that returns Time dimension member. |
Examples
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateBeforePeriodEnd([Measures].[Issue due date],
[Time].CurrentHierarchyMember)
)
)Above formula will count how many issues are due before end of current Time dimension period.