YTD
Description:
This function is used to return a set of sibling members from the Year level as a given member, starting with the first sibling and ending with the specified member.
Syntax:
Ytd([Member_Expression ])
Return type:
SET
Parameters:
Parameter | Description |
|---|---|
Member_Expression | A valid MDX Expression that returns a member. |
Example:
with member [Measures].[SYTD] as
Sum(YTD([Date].[Calendar].[Calendar Year].&[2011]),
[Measures].[Reseller Order Quantity])
SELECT [Measures].[SYTD] ON 0
FROM [AdventureWorksMF]