Forum Discussion
Sarutra
Helper I
Helper IPower bi query very slow
hello, Power bi query very slow. how to fix? #"Pridėta rodyklė" = Table.Buffer(Table.AddIndexColumn(#"Filtruotos eilutės5", "Indeksas", 1, 1, Int64.Type)), #"Pridėtas pasirinktinis1" = Table....
AlexisOlson
Super User
Super UserThis is a really inefficient way to calculate cumulative columns in Power Query. You'll have much better performance if you used a method like List.Accumulate instead.
Check out this post for an example:
https://community.powerbi.com/t5/Desktop/How-to-do-a-running-Sum-by-group-in-Power-Query/m-p/290123
Sarutrathanks, i'll try