DateBeforePeriodEnd

Returns if a date is before a time period end date.

Syntax

CODE

DateBeforePeriodEnd(date, Time_Member_Expression)

Arguments

date	Date expression.
Time_Member_Expression	MDX expression that returns Time dimension member.

Examples

CODE

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.