- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 :
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HI @prakash11440278 ,
Can you share a screenshot of your data?
Please check if the column are not text in Power Query.
Regards,
Harsh Nathani
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-16-2023 12:04 AM | |||
07-17-2023 04:32 PM | |||
03-08-2024 08:39 AM | |||
07-16-2024 08:11 AM | |||
Anonymous
| 06-21-2023 01:04 PM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |