Forum Discussion
carlosagarcia
Helper I
Helper IROUNDDOWN TIME
Hello guys, I am looking at using the ROUNDDOWN function. I want to ROUNDDOWN time in all transactions made in a specific hours throughout the day. Say there were 15 transactions between 9 am and 1...
You could find more explaination and examples about the "round up" for time below.
https://community.powerbi.com/t5/Desktop/Round-time-DOWN-to-the-nearest-5-15-30-minutes/td-p/311676
https://community.powerbi.com/t5/Desktop/Round-up-time-to-next-hour/td-p/701404
But, in your scenario, you could take a easy way as below:
Column = TIME(HOUR([time]),0,0)Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft
Community Support
Community SupportYou could find more explaination and examples about the "round up" for time below.
https://community.powerbi.com/t5/Desktop/Round-time-DOWN-to-the-nearest-5-15-30-minutes/td-p/311676
https://community.powerbi.com/t5/Desktop/Round-up-time-to-next-hour/td-p/701404
But, in your scenario, you could take a easy way as below:
Column = TIME(HOUR([time]),0,0)
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.