Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

My queries are running so slowly!

Hi Guys   Firstly, huge thanks with all the help you've provided so far. Piecing bits together from other answers has enabled me to get to this point, but now I'm stuck and I'm at my wits end.  Be...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous ,
could be that the reason for this lies in the function for the running total "fxSecRunningTotal". Could you please paste the code for it as well? 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Yeah sure:

    let
    Source = (values as list, grouping as list) as list =>

let
    GRTList = List.Generate
    ( 
        ()=> [ GRT = values{0}, counter = 0 ],

        each [counter] < List.Count(values),

        each try 
                 if grouping{[counter]} = grouping{[counter] + 1} 
                 then [GRT = [GRT] + values{[counter] + 1}, counter = [counter] + 1]
                 else [GRT = values{[counter] + 1}, counter = [counter] + 1]
        
             otherwise [counter = [counter] + 1]
    ,
        each [GRT]
    )
in
    GRTList
in
    Source