An argument of function 'INT' has the wrong data type or the result is too large or too small

[prakash11440278]

HI All,

I am facing below error in my measure while using Significant figures calculcation. Please help.

Exression : 

ROUND([Sales],2-(1+INT(LOG10(ABS([Sales])))))

[v-alq-msft · Accepted solution]

Hi, @prakash11440278 

There are limitations on data types in Power BI Desktop. When the value is too large or small, the error massage occurs.

The 'Decimal Number' type can handle negative values from -1.79E +308 through -2.23E -308, 0, and positive values from 2.23E -308 through 1.79E + 308. The largest value 'Fixed Decimal Number' can represent is 922,337,203,685,477.5807 (positive or negative). 'Whole Number' allows for 19 digits; positive or negative whole numbers between -9,223,372,036,854,775,807 (-2^63+1) and 9,223,372,036,854,775,806 (2^63-2).

Note:

The Power BI Desktop data model supports 64 bit integer values, but the largest number the visuals can safely express is 9,007,199,254,740,991 (2^53-1) due to JavaScript limitations. If you work with numbers in your data model above this, you can reduce the size through calculations before adding them to a visual.

For further information, please refer to the following document.

Data types in Power BI Desktop 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[prakash11440278]

HI @harshnathani ,

I have tried for whole number & decimal values still the same.

[harshnathani]

HI @prakash11440278 ,

Can you share a screenshot of your data?

Please check if the column are not text in Power Query.

Regards,

Harsh Nathani

[prakash11440278]

HI @harshnathani ,

Column which i am using is in General Format.

[harshnathani]

Hi @prakash11440278 ,

Can you change the column data type to any of the numeric format in Power Query and then try.