Forum Discussion
siva3012
Helper II
Helper IIHow to convert 15 Min interval data into one hour interval data?
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.
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.
