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,

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,

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

You are welcome.

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