cancel
Showing results for
Did you mean:
Helper III

## Calculating Average Cumulative value?

Hi

I am having below data

I want to calculate the average cumulative value . Need output as below. I did this calculation in Excel and sample excel file attached here https://we.tl/t-Y8TKJrgVYB

Average Cumulative of 484.50 for 30th Sep is average of all the values. For 29 sep, average cumulative is 482.86 is average of values from 23 sep to 28 sep. Same is applicable for other dates.

Can anyone advise me how to do this in Power BI?

2 ACCEPTED SOLUTIONS
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III
7 REPLIES 7
Community Champion

Try this:

``````Average cumulative =
CALCULATE (
AVERAGE ( table[Value] ),
FILTER ( ALL ( table ), table[Date] <= MAX ( table[Date] ) )
)``````

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Helper III

@VahidDM Thanks for your reply. Values are not coming correct. My value column in the table is measure. Is this something an issue?

Community Champion

Can you share the DAX code of the Value measure with a sample of your data?

Helper III

Thank you

I am having below table

Here the average column is a measure. Below caulcuation I did

Average Max = AVERAGE(Append1[Max_Price])
Average Min = AVERAGE(Append1[Min_Price])
Average = ([Average Max] + [Average Min]) / 2

Now, I want to calculate the cumulative average of average column

I need output as below

I want to calculate the average cumulative value . Need output as below. I did this calculation in Excel and sample excel file attached here https://we.tl/t-N2e7mLeMaF

Cumulative Average is 1045.428571 for 30th Sep is average of all the values. For 29 sep,  cumulative average is 1046.83333 is average of values from 29 sep to 30 sep. Same is applicable for other dates.

PBIX file attached here https://we.tl/t-0g7kEMYd7O

Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III
Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Launching new user group features

Learn how to create your own user groups today!