[1997].LastSibling

[Time].[1997].LastSibling.LastChild.LastChild

Tail(Filter( [Time].[Month].Members, NOT IsEmpty(Time.CurrentMember)),1).Item(0)