PeriodsToDate

Returns a set of sibling members from the specified level of a time dimension, beginning with the first sibling and ending with a specified member.

Syntax

PeriodsToDate( [ Level_Expression [ ,Member_Expression ] ] )

Input Parameters

Level_Expression: An MDX expression that returns a level.
Member_Expression: An MDX expression that returns a member.

Examples

This expression aggregates all sales for the past year, ending with the current date:

Aggregate(
      PeriodsToDate(
          [Order Date Dimension].[Order Retail445].[Order Reporting_Year],
          [Order Date Dimension].[Order Retail445].CurrentMember
          ),
      [Measures].[salesamount1]
  )