Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
30 days ago
Solved

Accumulated average

I want to accumulte the but as ans average,   so :  { 1, 1, 1 ,1} =  1 / 1 ,  2 /2 ,  3/3 , 4/ 4  so here the average is calculated in select; let alist = let alist = List.Number...
Need Help
Show and Tell
  • Dicken's avatar
    Dicken
    30 days ago

    I want the cuumulative average, the example i gave shows a correct result. 

slorin's avatar
slorin
Super User
27 days ago

Hi

List.Transform(
    {1..List.Count(alist)},
    each List.Average(List.FirstN(alist, _))
    )

 

List.Generate(
    ()=>[i=1, x=alist{0}],
    each [i]<=List.Count(alist),
    each [i=[i]+1, x= ([x]*[i]+alist{[i]}) / ([i]+1) ],
    each [x]
    )

Stéphane