Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cumulative Sum Measure

Hi all,   I'm struggling with creating a cumulative sum in Power BI desktop.  The cumulative sum would be used to figure out a buying schedule for one of our internal buyers here.  So the fields wi...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous,

Based on my test, you could refer to below formula:

Measure = CALCULATE(SUM(PRODPURCH[Quantity]),FILTER(ALL(PRODPURCH),'PRODPURCH'[Item number]<=MAX('PRODPURCH'[Item number])))

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Daniel,

 

Thank you for the response, but unfortunately this did not work, please see the attached image.  

 

At each change in quantity, I'd expect the 'Measure' measure to change along with it, but it does not.  Can you please advise?

 

Thanks, Gary

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    At each change in quantity, I'd expect the 'Measure' measure to change along with it

    What could you mean it? Could you please offer me your sample data to have a test?

     

    Regards,

    Daniel He