The moving average set to “previous 2, next 0” means a 3-month moving average. the naming is a little confusing, but you can check the figures and calculate and you will notice that the answer is correc – ex: February 2010 – 130534, March 2010 – 145616, April 2010 – 130543. The 3 month moving average for April 2010 is 135564 : (130534+145616+130543)/3.

For Question 3, shouldn’t SUM be a table calculation?

Hello,

Sum is not a table calculation. You can check the table calculations by right-clicking the measure from your visual -> Quick Table Calculations

Hope this helps,

Narcis

Seems to me that the right answer to question 4 is not listed, since the moving average is standard set to ‘previous 2, next 0’ (using version 2022.2)

Hi Bastiaan,

The moving average set to “previous 2, next 0” means a 3-month moving average. the naming is a little confusing, but you can check the figures and calculate and you will notice that the answer is correc – ex: February 2010 – 130534, March 2010 – 145616, April 2010 – 130543. The 3 month moving average for April 2010 is 135564 : (130534+145616+130543)/3.

Hope this helps,

Narcis