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