Returns the current member along the specified hierarchy during iteration.
CurrentMember ( dimension )
A dimension specification.
with
member measure.PROPORTION
as (measure.Turnover, currentMember(Date)) / (measure.Turnover, parent(currentMember(Date)))
select
children([Date].[ALL].[2022]) on 0,
{ measure.Turnover, measure.PROPORTION } on 1
from [Airline Turnover];
Q1 | Q2 | Q3 | Q4 | |
Turnover | 1844680154 | 1873449304 | 1875127569 | 1851193294 |
PROPORTION | 0.2477926609028949 | 0.25165717053886427 | 0.25188260894299547 | 0.24866755961524536 |