Forum Discussion

v-amarsh's avatar
v-amarsh
Microsoft Employee
6 years ago

Cumulative sum

Hi Community, I am trying to get a running total on a field based on condition on a different column. Below is my input table along with expected output column (Cumulative Assigned)to produce . Col...
Need Help
v-amarsh's avatar
v-amarsh
Microsoft Employee
6 years ago

Thanks for your reply chandrenstrom. I have tried using DAX version equivalent for Parento chart in Excel by some internet sources. However, the result is giving me scalar value of the total sum of values . 

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI v-amarsh,

If my formula not helpful, can you please share a pbix file with some dummy data and expected results to test?

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

  • v-amarsh's avatar
    v-amarsh
    Microsoft Employee
    6 years ago

    Hi Anonymous 

    Thanks for your reply. Please find the attached .pbix file. The table on the RHS is the output from the DAX formula.

    SUM function used in summarize will always give sum for a group together rather than cumulative progression sum what is expected. 

    Note : My cumulative sum should stop once it reaches the MAX value found in Resource Plan for that particular period. In this dummy data set, max value is seen for period FY20-P10. This can vary.

     

    I am unable to attach my .pbix here so sending the link for report. Request you to download .pbix from that link.

     

    https://msit.powerbi.com/groups/me/reports/19c5c614-0d1d-49ae-a681-55d54cb16729?ctid=72f988bf-86f1-41af-91ab-2d7cd011db47 

    Thanks