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

     

     

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