simple moving average

[dfs29]

I want to calculate the 10-minute moving average using a DAX measure.

This my formula : 

M = AVERAGEX(
FILTER(
'table',
'table'[C1]>= EARLIER('table'[C1]) - TIME(0,10,0) &&
'table'[C1] <= EARLIER('table'[C1])
),'table'[C2]
)

This is the result 

However, the result I'm getting is incorrect because if I calculate it manually, I should get 162.4 for 8:20:00, 214 for 8:30:00, 271.5, 195.92.

Does anyone have an idea please ? 

Thanks

[amitchandak]

@dfs29 , the new calculated column seem fine. Just check date  you are checking is correct

You can also try this

M =
Var _time = 'table'[C1]
return
AVERAGEX(
FILTER(
'table',
'table'[C1]>= _time - TIME(0,10,0) &&
'table'[C1] <= _time
),'table'[C2]
)