LASTPERIODS
Description:
This function is used to return a set of members up to and including a specified member.
Syntax:
LastPeriods(Index [ ,Member_Expression ] )
Return Type:
SET
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Index | A valid numeric expression that specifies a number of periods. |
Example:
SELECT
[Measures].[Internet Order Quanlity] on 0,
LastPeriods(5,[Customer].[Geography].[Country].&[Germany]) ON 1
FROM [AdventureWorksMF]