Average Per 5 minutes data

[Mulwanto]

Hello all,

I have data from sensor that record data every 5 minute, example as below.

then the question is, how to average column level to hours. Below the example output I want.

Time	Average of Level
12:00:00 AM	1.47
01:00:00 AM	1.46
02:00:00 AM	0.99
03:00:00 AM	0.45
04:00:00 AM	1.30

 Thanks.

[daXtreme · Accepted solution]

Use Power Query to do this. It's easy. Group the data by (date and) hour (the hour can be extracted from time easily - there's a button that does it for you), and apply the average function over the column(s) of your choosing.

[Mulwanto]

Hi daXtreme,

Thank's for the answer, this can be solution too, but how if I want the output in the Measure or another table.

[daXtreme]

If you create the table I'm talking about, you'll also be able to create a measure based on this.