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