cancel
Showing results for 
Search instead for 
Did you mean: 
0

Time function in DAX doesn't work for numbers larger than 32767 in seconds parameter.

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?

 

2019-02-24_21-35-16.png

Status: Delivered
Comments
Moderator

@soheil ,

Regarding to the above issue, you can submit a feature request in Power BI ideas forum.

Regards,
Lydia

Moderator
Status changed to: Delivered