Question 370
A report needs a moving-average transformation across a specific displayed axis. Which design may simplify it?
Explanation
Correct Answer
Use an appropriate visual calculation such as MOVINGAVERAGE when supported. Visual calculations can express running and moving windows over displayed points.
Incorrect Answers
Model measures are reusable across visuals and respect filter context. Its application is “reports and slicers. Where should it be defined”, not the need “a moving-average transformation across a specific displayed axis”.
Visual calculations operate on a visual matrix with limited function support. That is a different operating condition from “a moving-average transformation across a specific displayed axis”: “use RELATED to traverse model relationships and fails”.
Visual calculations evaluate over the visual result rather than the whole semantic model. The present requirement is “a moving-average transformation across a specific displayed axis”; “one matrix without defining a reusable model measure” is a distinct situation.