Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
need to create two helper columns in power query
and then calculate the average
see attached
https://dropmefiles.com/Wa1oj
Did not got your problem, Could you explain it more in detail with some sample data?
Thanks,
Arul
Sure!
I need to get average number of every 4 rows and create another column with those average numbers.
A B
1.12 | 1.205 |
1.11 | 1.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. 🙂
need to create two helper columns in power query
and then calculate the average
see attached
https://dropmefiles.com/Wa1oj
Thank you very much!
But what if I have 30 columns each containing 35138 rows?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |