Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everybody,
I have a field in format of time like 9:03:45 or 9:46:12.
I need to make a new field where I would round the times to the nearest hour, for example:
9:03:45 -> 9:00
9:46:12 -> 10:00
How can I do that in Power BI?
Thank you.
Tereza
Solved! Go to Solution.
Hi @TessGaston
You can do this in DAX or M languages depending where you want the calculation to happen.
If <original time> is the original time value:
DAX:
Round time to nearest hour ( TIME(1,0,0) = 1/24 representing an hour) and add a zero time value to ensure the expression is cast as a Time.
MROUND ( <original time>, TIME ( 1, 0, 0 ) ) + TIME ( 0, 0, 0 )
M:
There isn't an equivalent of MROUND in M, so instead multiply the time by 24 to express it as a number of hours, then round, then divide by 24 and convert to a Time type.
Time.From( Number.Round( Number.From( <original time> ) * 24 ) / 24 )
Regards,
Owen
Hi @TessGaston,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry
Hi @TessGaston
You can do this in DAX or M languages depending where you want the calculation to happen.
If <original time> is the original time value:
DAX:
Round time to nearest hour ( TIME(1,0,0) = 1/24 representing an hour) and add a zero time value to ensure the expression is cast as a Time.
MROUND ( <original time>, TIME ( 1, 0, 0 ) ) + TIME ( 0, 0, 0 )
M:
There isn't an equivalent of MROUND in M, so instead multiply the time by 24 to express it as a number of hours, then round, then divide by 24 and convert to a Time type.
Time.From( Number.Round( Number.From( <original time> ) * 24 ) / 24 )
Regards,
Owen
Thank you very much! Simple and very effective solution
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |