Forum Discussion
grouping time
dears,
good day!!
i have this time column and i would like to group the time for every one hour can any one help?
160475
In Power Query, under Add Column tab, click on Time then Hour. you can group using this hour column.
2 Replies
- amitchandakSuper User
160475 , you need to convert that second, add, and again display in duration format
refer
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389