Returns the last child of the given member.
This function returns a member.
Syntax and Details
FeedbackOpens in a new tab
member_expression is an expression that returns a member.
This expression cannot refer to a measure.
The function returns the last child of this member. To determine which child is last, the function considers the default order of the set of children.
SELECT MEASURES.[%COUNT] ON 0, homed.zip..LASTCHILD ON 1 FROM patients Patient Count Pine 1,100
To see a picture of the hierarchy used in this example, see the FIRSTCHILD function.
For another example:
SELECT MEASURES.[%COUNT] ON 0, birthd..LASTCHILD ON 1 FROM patients Patient Count Dec-1950 8