MTD
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 the Year level in the Time dimension.
Syntax:
Mtd( [ Member_Expression ] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
with member [Measures].[SMTD] as
Sum(MTD([Date].[Calendar].[Month].&[2011]&[1]&[1]&[January]),
[Measures].[Reseller Order Quantity])
SELECT [Measures].[SMTD] ON 0
FROM [AdventureWorksMF]