Calculate the average of last sprints

[pva]

Hello everyone

I have a table where I want to show the average speed of the last sprints of the selected project. I mean, in sprint 1 in want to show 0 as there are not previous sprints, in sprint 2 I want to show the average of the sprint 1, in sprint 3 i want to show the average of sprint 1 and 2 and so on. The table should look like this:

Sprint Number	Speed	Avg Speed
1	4	0
2	8	4
3	9	6 -> (8+4)/2
4	6	7 -> (9+8+4)/3

Any idea?

Thank you very much!!

[smpa01 · Accepted solution]

@pva  you can write a measure like this

Measure =
IF (
    MAX ( 'Table'[Sprint Number] ) = 1,
    0,
    CALCULATE (
        AVERAGE ( 'Table'[Speed] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Sprint Number] < MAX ( 'Table'[Sprint Number] )
        )
    )
)

[pva]

@smpa01 thanks a lot!!! It worked perfectly!