Calculating Average Cumulative value?

[bourne2000]

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?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[VahidDM]

Hi @bourne2000 

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.

Appreciate your Kudos!!

[bourne2000]

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

[VahidDM]

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

[bourne2000]

@VahidDM 

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Syndicate_Admin]

Hello!
Way you can share the file with me? I have a similar problem and would like to open the code that was used 🙂

[Ashish_Mathur]

Hi,

I do not have that file now.  Share some data to work with, explain the question and show the expected result.

[bourne2000 · Accepted solution]

@Ashish_Mathur  Thanks. 

[Ashish_Mathur]

You are welcome.