LastChild

Syntax

Member_Expression.LastChild

Arguments

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

This formula is useful inside longer and more complex formulas. If this formula is used on its own for a custom measure, it will be paired with the default "Issues created" measure and return the same result as the following formula:

(
  [Measures].[Issues created],
  [Time].CurrentHierarchyMember.LastChild
)

Return the name of the last member of a period

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.