# Calculating rolling average velocity for each sprint

Hello Team ,

I have a requirement wherein I want to publish the rolling average velocity for each sprint that is part of my calculated member " last 6 sprints ".

For ex : Sprint 1 to Sprint 6 are my last 6 sprints. Then the report should look like

Avg vel. for Sprint 1 = story points completed in sprint 1

Avg vel for Sprint 2 = (sum of story points completed ( Sprint 1 + Sprint 2 )) / 2

And so on …

Hi,

A standard measure gives the average velocity for the last 5 sprints (Running Story Points velocity for 5 closed sprints). You may check that the same formula can be reused, replacing the 5 with 6.

If you have a completely customized Sprint member, the following universal solution can be applied:

``````Sum(
Head(
ChildrenSet([Sprint].[Last 6 closed sprints]),
Rank([Sprint].CurrentHierarchyMember,
ChildrenSet([Sprint].[Last 6 closed sprints]))
),
[Measures].[Sprint Story Points completed]
)/
Rank([Sprint].CurrentHierarchyMember,
ChildrenSet([Sprint].[Last 6 closed sprints]))
``````

The report could look like this:

Kindly,
Janis, eazyBI support

Hi @janis.plume ,

How is ‘Last 6 closed sprints’ calculated?

Hi,

The following formula is behind the last 6 closed sprints:

``````Aggregate(
Head (
Order(
Filter([Sprint].[Sprint].Members,
[Sprint].CurrentHierarchyMember.getBoolean('Closed') AND
NOT IsEmpty([Sprint].CurrentHierarchyMember.get('Complete date'))),
[Sprint].CurrentHierarchyMember.get('Start date'),
BDESC
),
6)
)
``````

Kindly,
Janis, eazyBI support