Skip to main content
Version: I2022.4.1

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