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.
I have a Custom Column with the following:
24 Hour =Time.From( Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24 )
I need to add code to account for time that is 11:30 PM and later as it creates an error as it can not do 24:00.
Also I want to add, if null then No Entry.
Can I do that in Custom or can I convert Custom to Conditional Column?
Solved! Go to Solution.
That was close.
I had to use
Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24=1 then 0.0 else Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24)
This allowed time under :30 to go back to the hour.
@bdehning , If data type is time, Then 24 hours display is just a display property
or you can try like
Time(hour([Time]), Minute([Time]), 0)
If this does not help
Can you share sample data and sample output in table format?
Using 24 Hour Claims =Time.From( Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24 )
I get the following, How do I account for the error because of the time that is 11:46:00?
Hi, @bdehning
You can try the following methods.
Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24=1 then 0.5 else Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It's really close. How do I get any time with :30 to round up to the next hour?
It currently rounds down
Hi, @bdehning
You can try changing Number.Round to Number.RoundUp.
Time.From(if Number.RoundUp( Number.From( [Time of Incident] ) * 24 ) / 24=1 then 0.5 else Number.RoundUp( Number.From( [Time of Incident] ) * 24 ) / 24)
Does this meet your desired outcome?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That was close.
I had to use
Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24=1 then 0.0 else Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24)
This allowed time under :30 to go back to the hour.
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 |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |