Not getting Cumulative value step by step for Diff Countries.

[jay_patel]

Hey Guys,

In my Power BI Report I want a cumulative value for every country, and from the next country it should starts based on the value for next country,  the attachments and the dax are mentioned below, Please reply for the same if anyone got the issue or dax as soon as possible. One more thing is that if i use the "Index" column instead of using "ActualMonth" I got proper values, but the problem is that when i load the countries around (45-50) it gives low memory space error,So i just want to get the exact Cumulative based on actualmonth in dax. 

Thanks in advance guys.This is my cumulative formula , which gives only single value in every row i.e, "100"Actualmonths for one country

[PhilipTreacy]

@jay_patel 

In case you are interested in a solution using Power Query rather than DAX.  It's super fast

https://www.myonlinetraininghub.com/grouped-running-totals-in-power-query

Regards

Phil

[jay_patel]

I cant work on power query , because my major columns are calculated So i cant move them to power query editor.

[amitchandak]

@jay_patel ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[jay_patel]

here I have selected a single countrycode, and as you can see the cumulative for increase & decrease also addding values of other countries.

[Icey]

Hi @jay_patel ,

It is needed to create a measure. Please share me some sample data and your desired result for test.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

[jay_patel]

How can i share sample data, I mean can i upload any csv file or xls?