Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: example

...

 DateBeforePeriodEnd(date, Time_Member_Expression)

Arguments

dateDate expression.
Time_Member_ExpressionMDX expression that returns Time dimension member.

Examples

...

count(
Filter(

...

 

...

Descendants([

...

Invoice].CurrentMember, [

...

Invoice].[

...

Invoice]),

...

  DateBeforePeriodEnd([

...

Invoice]

...

.CurrentMember.getProperty('Due date

...

'), 

...

[Time].CurrentHierarchyMember)

...

)

...


)

Above formula will count how many issues Invoices are due before end of current Time dimension period.

...