Forum Discussion
androo235
Advocate I
Advocate IRunning Total by Category with Compound Interest. List.Accumulate/Generate
Data and XL solution and attempts to solve with Power Query I have been trying to solve this problem with power query. I started by using refer to previous row methods but thought these would li...
ImkeF
Community Champion
Community ChampionHi androo235 ,
it should be possible to do this fast in PQ using the right method:
Memory efficient clustered running total in Power BI – (thebiccountant.com)
I have been using this on millions of rows without any issues.
I you are having trouble applying it to your case, please re-open the file you had shared.