Moving Average

[ilcaa]

Using Power Query.... I wanted to create a 3 period Moving Average, if I do this in Excel, it would look like this screenshot... What is the syntax to create this Column? thanks

1.sum current "test" value and previous 2
2. sum current "BDs_perWeek" and previous 2
3. divide test/BDs_perWeek
4. do it for each row

 

[Leo Skywalker]

Hi there,

Why don't you just remove the $ signs for the referenced rows?