Forum Discussion
Power Query - Error while rounding off time
Hi Team,
I wanted to round off my time column into the nearest hour in Power Query and it worked for most of the data, but about 20% of the data has errors now and I am not able to understand why.
Here's a snapshot and this is the code I used : Time.From(Number.Round(Number.From([IST Time])*24)/24)
Can anyone help me understand how to fix this? Or suggest a better code to use.
8 Replies
Hey galbatrox9
You don't have to use DAX for this. I would just duplicate the column, retitle it, and then in query editor change the format to HH under the Transform tab. See this article for more information: https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
If this helps please kudo.
If this answers your question please accept it as a solution.
Hi Anonymous ,
Thats neat, but what if i wanted to round to the nearest hour? In your way, 10:45 PM would be converted to 10 PM, but i want it to come to 11 PM.
My bad. I forgot formatting doesn't round. In that case you were on the right track. The answer you're looking for is in this post: https://community.powerbi.com/t5/Desktop/How-to-round-minutes-in-time-to-the-nearest-hour/td-p/476432
