Forum Discussion

siva3012's avatar
siva3012
Helper II
9 years ago
Solved

How 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. 

 

 

 

 

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    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.

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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!