Forum Discussion
MAA - Calculation
Dear all, I'm trying to calculate the MAA (Moving Annual Average) value - but I would need your help on this KPI & DAX language. Data are like this: -> Conformity level (Grade A = OK/NON OK per sc...
Anonymous , First create a separate year period table with period rank column and join both on yearperiod combine column
Period Rank = RANKX(all('Period'),'Period'[year period],,ASC,Dense)
Then you can measure like
This Period = CALCULATE([% Grade A ], FILTER(ALL('Period'),'Period'[Period Rank]=max('Period'[Period Rank])))
Last Period = CALCULATE([% Grade A ], FILTER(ALL('Period'),'Period'[Period Rank]=max('Period'[Period Rank])-1))
Last 13 Period = CALCULATE([% Grade A ], FILTER(ALL('Period'),'Period'[Period Rank]>=max('Period'[Period Rank])-13 && 'Period'[Period Rank]<=max('Period'[Period Rank])))
Hello,
What does it mean -> ASC,Dense?
Thanks