CLOSINGPERIOD
Description:
This function is used to return the member that is the last sibling among the descendants of a specified member at a specified level.
Syntax:
ClosingPeriod( [ Level_Expression [ ,Member_Expression ] ] )
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Level_Expression | It is a valid MDX expression that returns a level. |
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
SELECT
[Measures].[Internet Unit Price] on 0,
ClosingPeriod([Customer].[Geography].[Country],
[Customer].[Geography].[Country].&[Australia]) ON 1
FROM [AdventureWorksMF]