How to convert 15 Min interval data into one hour interval data?

[siva3012]

Hi, I have data consiting on every 15 min interval and i have to convert this into one hour interval data. Can anyone guide me in doing this in PowerBI?  I have the screenshot which is required. 

[Eric_Zhang · Accepted solution]

@siva3012

In Query editor window, you can try to add a custom column as 

Time in Hours = Time.Hour([time in Min])+1

And then group by usage date and Time in Hours.

See more information in the attached pbix file.

[Anonymous]

I had a very similar question except that my field is formatted as a date and time, with the time being in 15 minute intervals. Is there a similar formula that I can use?

Thanks!

[siva3012]

@Eric_Zhang: Thanks Eric.  Its Perfect .