Forum Discussion

siva3012's avatar
siva3012
Icon for Helper II rankHelper 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.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft 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.

  • siva3012's avatar
    siva3012
    Icon for Helper II rankHelper II
    9 years ago

    Eric_Zhang: Thanks Eric.  Its Perfect .

  • 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!