/
DateBeforePeriodEnd
Document toolboxDocument toolbox

Support center for flex.bi version 3.2

DateBeforePeriodEnd

Owned by Gvido
Sept 01, 2016

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

Syntax

 DateBeforePeriodEnd(date, Time_Member_Expression)

Arguments

dateDate expression.
Time_Member_ExpressionMDX 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.

See also