Aggregate minute data to hourly in a day

[srirama]

Hi team,

Please help me how to aggregate minute data to hourly in a day. Please refer below images.

Original Table

Date	Time	TAP	AP	AcP	SL
01-07-2022	00:00	8	3	8	7
01-07-2022	00:01	9	6	8	9
01-07-2022	00:02	6	8	4	4
01-07-2022	00:03	8	3	5	3
01-07-2022	00:04	8	5	5	3
01-07-2022	00:05	5	3	4	8
01-07-2022	01:00	8	6	2	5
01-07-2022	01:01	7	5	7	3
01-07-2022	01:02	3	7	8	8
01-07-2022	01:03	4	6	3	8
01-07-2022	01:04	8	3	6	6
01-07-2022	01:05	3	2	8	6

[v-jianboli-msft · Accepted solution]

Hi @srirama ,

Approve with @amitchandak , besides you can try:

First add a new column:

Hour = TIME(HOUR([Time]),0,0)

Then you can add the field you need and choose the correct aggregation:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@srirama , You can have a new colum

if time is text 

= left([time],2)

if time is time data type

format([time], "hh")

and then you can group the data by hour

or you can take help from time table

https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/