Forum Discussion
Helper IVNot getting Cumulative value step by step for Diff Countries.
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
6 Replies
- amitchandak
Super User
jay_patel ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- jay_patel
How can i share sample data, I mean can i upload any csv file or xls?
- 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
Community Support
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
- PhilipTreacy
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.
