Calculate average of all previous entries

[Minette]

Hi there,

I am trying to calculate the average of all previous entries as a kind of moving average, taking into account all the entries up to the most recent entry. My entries is by chronological ID, and the field I like the average of is "Ratio". The average for each record should therefor be the average of all ratios up to that entry. Each average will therefor have 1 more value contributing to the average than the previous record's average.

Any advice will be greatly appreciated.

[Zubair_Muhammad · Accepted solution]

Hi @Minette

Try this MEASURE

Measure =
AVERAGEX (
    FILTER ( ALL ( Table1[ID] ), Table1[ID] <= SELECTEDVALUE ( Table1[ID] ) ),
    CALCULATE ( SUM ( Table1[Ratio] ) )
)

[Minette]

Thank you Zubair! It works like a charm! Much appreciated!!!