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,

    And more baiscally can I use this formula:

    YTD 2021 = Divide(CALCULATE(COUNTROWS(rclms_qa), FILTER(rclms_qa,rclms_qa[CONFORMITY]="OK"&&rclms_qa[Mars Year]=2021)),CALCULATE(COUNTROWS(rclms_qa), FILTER(rclms_qa,rclms_qa[Mars Year]=2021)))*100
     
    And get the results (adding a DAX formula) of the last 13 periods (from today until the last 13 periods).
    Thanks
    Hervé
    • v-henryk-mstf's avatar
      v-henryk-mstf
      Community Support
      5 years ago

      Hi Anonymous ,

       

      Yes, your formula is also a good way. If the problem has been solved or my reply provided you with help, you can mark it as the correct answer to to help the other members find it more quickly.😊


      Best Regards,
      Henry

  • 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.