simple moving average

[dfs29]

hello, 

This is my dax formula :

simple moving average (SMA) =
AVERAGEX(
FILTER(
'table',
'table'[Time]>= EARLIER('table'[Time]) - TIME(0,10,0) &&
''table'[Time] <= EARLIER('table'[Time])
),
'table'[activity]
)

this is the result : 

I dont understand how we have the result of sma column.

With my dax formula I would like to have 187 for 9:40 because we do (217+157)/2 

for 9:50 we do (429+217)/2 

can anyone help me pleaase

[amitchandak]

@dfs29 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.