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