Forum Discussion
Solved
How to round a datetime value to datetime hours with Power Query (M)
Hello buddies. I'd be grateful if you help me code the following. I need to round the minutes to the down hour like the image, this using power query (M). Thanks for all.
rmcneish , Try in a new column in power query
=Time.StartOfHour([Datetimestamp])
If you need end
=Time.EndOfHour([Datetimestamp])
rmcneish , Try in a new column in power query
=Time.StartOfHour([Datetimestamp])
If you need end
=Time.EndOfHour([Datetimestamp])