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]
)