Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Dicken
Post Prodigy
Post Prodigy

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.Numbers(1, 12, 1)
    in
      alist,
  result = List.Generate(
    () => [x = 0, y = alist{0}, z = y / (x + 1)],
    each [x] < List.Count(alist),
    each [x = [x] + 1, y = alist{x}, z = [z] + y],
    each [z] / ([x] + 1)
  )
in
  result


but can i get the average in the function, i have tried various such as ;

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



i have played around with various x = 0 , x = 1 etc. but cannot get one to work?

1 REPLY 1
ronrsnfld
Super User
Super User

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}??

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors