aggregation of rows

[Alirezam]

Hi dudes,

I have tons of data in half-hour format and want to aggregate them to hourly format adding two half-hour data together for each hour. The excel sample is attached. Any idea how to do it in Power bi or even excel?

what I want to see is the "Sum" column which is sum of kWh,

Regards,

https://1drv.ms/x/s!Al3r7IU8GY3yxT2t81XOpq0xdmcj?e=lTUTAP

[jdbuchanan71]

ello @Alirezam 

In PowerQuery, when you pull the information in, if you select the time column you can transform it to "Start of hour". The do another time transform to go to time only.

[Alirezam]

Yes, but this was not my answer, may you please read again what I had asked? Thanks anyway

[jdbuchanan71 · Accepted solution]

Once you have the correct time on each row you just need a measure 

Sum = SUM ( table[kWh] )

then you pull the Year, Month, Day and time from the table and add in the measure.