Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

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

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])))))
 

 

 

 

Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    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.

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      prakash11440278
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      HI Anonymous ,

      Column which i am using is in General Format.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi prakash11440278 ,

         

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

         

  • prakash11440278's avatar
    prakash11440278
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    HI Anonymous ,

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

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.