Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Averaging every 4 rows

Hello, I have values for 15 min for 3 years. I need to make an hour average of 4 15 min rows. I couldn't find topic related to this so I'm asking for help. Thank you in advance
Need Help
Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

Anonymous ,

Did not got your problem, Could you explain it more in detail with some sample data?

Thanks,

Arul

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sure!
I need to get average number of every 4 rows and create another column with those average numbers.

  A         B

1.121.205
1.111.795
1.09 
1.5 
1.78 
2 
2.1 
1.3 

 

B1 = AVERAGE(A1:A4)
B2 = AVERAGE(A5:A8) and so on...
Thank you so much for replying. ðŸ™‚

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    need to create two helper columns in power query
    and then calculate the average
    see attached
    https://dropmefiles.com/Wa1oj

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you very much!
      But what if I have 30 columns each containing 35138 rows?