Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi Anonymous ,

 

The basis for processing the same ranking, skip stands for sparse ranking, and the next ranking is equal to the number of all previous rankings + 1; dense stands for dense ranking, which only accumulates the ranking, regardless of the number. Use skip by default. ASC stands for ascending order, DESC is used by default.

 

I did a test, it can be used as a reference:

M1 = RANKX('Table',[Value],,ASC,Dense)
M2 = RANKX('Table',[Value],,ASC,Skip)

 

For specific formulas, please refer to the blog link provided by me:RANKX – DAX Guide


Best Regards,
Henry

If this post also helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello

If you take my example above, what do you mean by "value"?

Thanks

Hervé

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous ,

     

    The "value" field is the column I need to sort.


    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.