Returns the last child of the parent of a specified member.
LastSibling ( member [, hierarchy ])A member specification.
Optional. A specific hierarchy within the Time dimension.
select
{ ( LastSibling([starting date].[2020]) ) } on 0,
{ (measure.income), (measure.cost) } on 100
from [logistics.test];
| 2021 | |
| income | 126216.19799999952 |
| cost | 89645.33876600079 |