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
chadrenstrom's avatar
chadrenstrom
Advocate I
6 years ago

Not an answer, but similar idea to the Pareto chart in Excel.  Unfortunately the Pareto chart doesn't exist in Power BI, but there have been a few blog posts around the internet on how to create them.  The order changes based on the group total, so depending what you need, adding an index column prior to any calculations may not be the solution you need.   Then again, this may be a step further than you're looking for.

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-amarsh,

        I can't access your link, can you please upload the sample to 'onedrive for business' and share the link here?
        Regards,

        Xiaoxin Sheng