Forum Discussion
rmcneish
5 years agoHelper I
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])
1 Reply
- amitchandakSuper User
rmcneish , Try in a new column in power query
=Time.StartOfHour([Datetimestamp])
If you need end
=Time.EndOfHour([Datetimestamp])