Forum Discussion
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...
I want the cuumulative average, the example i gave shows a correct result.
Not sure what you want for a result.
What result would you like to see for your List.Numbers(1,12,1) list?
Your code gives the average where for each row n, the average of values alist{0..n}
Perhaps if you gave an example other than {1,1,1,1}??
posssibel method adapted from post prodigy;
let
alist = {1..12},
Custom1 = List.Generate( ()=> 1,
each _ < List.Count( alist ) ,
each _ + 1, each List.Average( List.Range( alist, 0,_ )) )
in Custom1