Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Moving average without date and a condition

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

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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])
    )
    )

     

     

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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])
    )
    )