Forum Discussion

bourne2000's avatar
bourne2000
Helper V
4 years ago
Solved

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.t...
Need Help
Show and Tell
VahidDM's avatar
VahidDM
Super User
4 years ago

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

bourne2000's avatar
bourne2000
Helper V
4 years ago

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's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 years ago

        You are welcome.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      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's avatar
        Ashish_Mathur
        Super User
        2 years ago

        Hi,

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