Time function in DAX doesn't work for numbers larger than 32767 in seconds parameter.
Submitted byAnonymouson02-24-201912:42 AM
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?