PERIODSTODATE
This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here. |
|---|
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 |
|---|---|
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]