issue with Round()

[illusionek]

Hello!

I am trying to use this (I hoped) simple function in PowerPivot and got below error message:

'ROUND' has the wrong data type or the result is too large or too small.

I am not sure what's the probem, if I remove round() the calculation works well.

Please help!

=round(([ExpiryDate]-today())/RELATED('Item Master'[Shelf life days]),0)

 

[scottsen]

This rings familiar, but I don't recall how/why I saw this For lack of a better plan... I would try putting the [ExpiratyDate]-today() into it's own column, to make sure the data type is a decimal. It might be defaulting to a date type and freaking out?

 

[illusionek]

Unfortunately I did not help. It must be an error in PowerPivot with data type date. Funny enough I was getting the same error for RoundUp() but RoundDown() was working fine for the same data set.

I ended up using Fixed()

 

[scottsen]

Nice, never used FIXED(). Thanks for following up w/ your solution