Moving average without date and a condition

[Anonymous]

Hi together,

I would like to calculate the moving average with the formula above with the condition that the interval between the indizes  which I use for the calculation equals the variable days always.

Thank you in regard for your help. 🙂

Moving Average = 
Var Days = 3
VAR MyIndex =  Table1[Index]

VAR myResult = 
    AVERAGEX(
        FILTER(
            'Table1',
            'Table1'[Index] > MyIndex-Days && 
            'Table1'[Index] <= MyIndex
           ),'Table1'[Value]
           )
RETURN 
myresult

[amitchandak · Accepted solution]

@Anonymous , Create a separate index table and join back to this table

And try a new measure like

Calculate(
AVERAGE(Table1, 'Table1'[Value]),
FILTER(
'Index',
'Index'[Index] > max('Index'[Index]) -3 &&
'Index'[Index] <= max('Index'[Index])
)
)