Returns the last sibling among the descendants of a member at a specified level.
ClosingPeriod([«Level»[, «Member»]])
The dimension that contains «Level» is used if «Level» is specified; otherwise, the Time dimension is used. If no «Level» is specified, the level below that of «Member» is used. If no «Level» or «Member» is specified, the default is Time.CurrentMember.
This function is equivalent to BottomCount(Descendants(«Member», «Level»), 1).
The OpeningPeriod function is similar, except that it returns the first sibling instead of the last sibling.
The following example returns [1991].December
:
ClosingPeriod(Month, [1991])