How to round a datetime value to datetime hours with Power Query (M)

[rmcneish]

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.

[amitchandak · Accepted solution]

@rmcneish , Try in a new column in power query

=Time.StartOfHour([Datetimestamp])

If you need end

=Time.EndOfHour([Datetimestamp])