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