Forum Discussion

rmcneish's avatar
rmcneish
Helper I
5 years ago
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])

1 Reply

  • rmcneish , Try in a new column in power query

     

    =Time.StartOfHour([Datetimestamp])

     

    If you need end

    =Time.EndOfHour([Datetimestamp])