PERIODSTODATE

Description:

This function is used to return a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by a specified level in the Time dimension.

Syntax:

PeriodsToDate( [ Level_Expression [ ,Member_Expression ] ] )

Return type:

SET

Parameters:

Parameter	Description

Parameter	Description
Level_Expression	It is a valid MDX expression that returns a set.
Member_Expression	It is a valid MDX expression that returns a member.

Example:

WITH MEMBER [Measures].[Calendar] AS
    Aggregate(
        PeriodsToDate(
            [Date].[Calendar].[Calendar Year],  
            [Date].[Calendar].[Calendar Year].&[2011]
        )
    )
SELECT  
    {[Measures].[Calendar],[Measures].[Order Count]} ON COLUMNS,
    [Product].[Product Categories].Children ON ROWS
FROM
     [AdventureWorksMF]