Using TIME funsiont with numbers larger than 32,767 in the "Seconds" argument, throughs "An parameter of function 'TIME' has the wrong data type or the result is too large or too small." error.
While this is a known restriction in the TIME function (thanks Måns Barklund for mentioning the link on Facebook) it would be better if the TIME function could convert any values greater than 59 in the "second" parameter to hours, minutes, and seconds. While the current version of TIME function works totally fine for the numbers smaller than 32,767 seconds why not covering bigger ranges like 86,400?
Comments
-
v-yetao1-msft
on:
Error when creating app
-
v-xiaoyan-msft
on:
Calculated column creation in composite models bro...
-
v-yetao1-msft
on:
My POWER BI APP keeps collapsing wh
-
v-xiaoyan-msft
on:
The page to submit a support ticket is not working
-
v-yetao1-msft
on:
Problema no Relatório Paginado
-
v-xiaoyan-msft
on:
This visual has exceeded the available resources
-
v-xiaoyan-msft
on:
Conditional formatting and dates filter
-
v-xiaoyan-msft
on:
PULSE Coaching Report not updating.
-
v-yetao1-msft
on:
Error message while shareing
-
v-xiaoyan-msft
on:
Reports have not been automatically refreshing sin...