LastChild
Returns the last child of a specified member.
Syntax
Member_Expression.LastChild
Arguments
| Member_Expression | MDX expression that returns a member. |
|---|
Examples
Return the last time member of a period
The following formula will return the last child member of a time member. For example, if the Quarter level is used in the report, this formula will return the last month for each quarter.
[Time].CurrentHierarchyMember.LastChild
You can also retrieve the name of the last child member.
[Time].CurrentHierarchyMember.LastChild.Name
See also
- Function FirstChild returns the first child of a member.
- Function Children returns a set of all children of a member.
- Function LastSibling returns the last sibling at the same level as the member.
- Function Parent returns the parent member of a member.