Forum Discussion
Solved
Rounding to nearest 30 min Time. Code errors out if time is after 11:30PM rounding to next day.
Hello. I am using the following code to create a new column to round to the nearest 30 minutes. = Table.AddColumn(#"Added Conditional Column", "RoundedTime", each Time.From(Number.RoundUp(48*Numb...
Oh, sorry about that (it is a bit difficult to double check the syntax when I don't have the full query). This should be the correct version:
Table.AddColumn(#"Added Conditional Column", "RoundedTime", each Time.From(Number.Mod(Number.RoundUp(48*Number.From(Time.From([TABLE_DATE_TIME]))/1)/48, 1)), type time)Note: When I ran the first query I put, I got a different error.
Error using the above code.
Expression.Error: We cannot convert the value 1 to type Type.
Details:
Value=1
Type=[Type]
Oh, sorry about that (it is a bit difficult to double check the syntax when I don't have the full query). This should be the correct version:
Table.AddColumn(#"Added Conditional Column", "RoundedTime", each Time.From(Number.Mod(Number.RoundUp(48*Number.From(Time.From([TABLE_DATE_TIME]))/1)/48, 1)), type time)
Note: When I ran the first query I put, I got a different error.
That resolved the issues. Thank you!