Forum Discussion
Slow Running Total and Total from a Table Column
Hi Hashiru ,
You could try to use Table.buffer which might will optimize the performance to see whether it work or not. You could refer to Running Total in Power Query and Memory efficient clustered running total in Power BI for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks to the dax community team, I tried the Mike Gavin solution and plug off the function I used before and change the invocation as follows:
#"Added Index" = Table.AddIndexColumn(LaborCostsBillingRulesKey, "Index", 1, 1),
BufferedTable = Table.Buffer(#"Added Index"),
#"Added Custom" = Table.AddColumn(BufferedTable, "RT", (OT) => List.Sum(Table.SelectRows(BufferedTable,(IT) => IT[FundScopeALIProjActivity]=OT[FundScopeALIProjActivity])[#"Federal Reimb."]))
The queries run in about 20 minutes but the load to either the worksheet or the data model is still a problem. After all the manipulation I need to have the output in csv file. This mean that I need to load the data into excel eventually.
How do I improve on the load time as It takes 12 hours plus to do the load of 120,000 rows?