How to calculated the average for the last 3 versions

[EsterBR]

Hi,

I have the following table and I would like to calculate the average of the las 3 release versions:

v5 should show the average of v4, v3 and v2; v4 should show the average of v3, v2 and v1; and so on. How can I achieve that with Power BI?

Thanks you so much!

Esther

[DataInsights · Accepted solution]

@EsterBR,

There are a few ways to achieve this. This approach uses the new preview feature Visual Calculations. The article below provides detailed instructions. Here's the DAX you would use. Make sure your measure [Sum of sprint] is an explicit measure.

Moving Average = MOVINGAVERAGE ( [Sum of sprint], 3, FALSE )

Here's how I set the format (Format Pane):

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview 

[EsterBR]

Thanks @Anonymous, Is it possible to do it without a visual calculation? I do not have that option in Power BI.

[DataInsights · Accepted solution]

@EsterBR,

It's possible to do this without a visual calculation, but the DAX is more complex. You have to enable this preview feature in Options:

[DataInsights · Accepted solution]

@EsterBR,

There are a few ways to achieve this. This approach uses the new preview feature Visual Calculations. The article below provides detailed instructions. Here's the DAX you would use. Make sure your measure [Sum of sprint] is an explicit measure.

Moving Average = MOVINGAVERAGE ( [Sum of sprint], 3, FALSE )

Here's how I set the format (Format Pane):

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview