Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
2 like 0 dislike
in Power BI by 1 1 4

In Power BI, I would like to know What's the main differences between the below data types

  • Whole Number data type.
  • Decimal Number data type.
  • Fixed Decimal Number data type.

1 Answer

2 like 0 dislike
by 54 119 241
selected by
Best answer

Decimal Number Vs Whole Number Vs Fixed Decimal Number

Power BI supports three number types:

  1. Decimal Number.
  2. Whole Number.
  3. Fixed Decimal Number.

Supported data types in Power BI-min

Decimal Number

  1. Represents a 64 bit (eight-byte) floating-point number.
  2. It’s the most common number type and corresponds to numbers as you usually think of them.
  3. Although designed to handle numbers with fractional values, it also handles whole numbers.
  4. 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.

    For example, numbers like 34, 34.01, and 34.000367063 are valid decimal numbers.

  5. The largest value that can be represented in a Decimal Number type is 15 digits long.
  6. The decimal separator can occur anywhere in the number.
  7. The Decimal Number type corresponds to how Excel stores its numbers.

Whole Number

  1. Represents a 64 bit (eight-byte) integer value.
  2. Because it’s an integer, it has no digits to the right of the decimal place.
  3. It 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).
  4. It can represent the largest possible number of the various numeric data types.
  5. As with the Fixed Decimal type, the Whole Number type can be useful in cases where you need to control rounding.

    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.

Fixed Decimal Number

  1. Has a fixed location for the decimal separator.
  2. The decimal separator always has four digits to its right and allows for 19 digits of significance.
  3. The largest value it can represent is 922,337,203,685,477.5807 (positive or negative).
  4. The Fixed Decimal Number type is useful in cases where rounding might introduce errors.
  5. When you work with many numbers that have small fractional values, they can sometimes accumulate and force a number to be slightly off.
  6. Since the values passed the four digits to the right of the decimal separator are truncated, the Fixed Decimal type can help you avoid these kinds of errors.
  7. If you’re familiar with SQL Server, this data type corresponds to SQL Server’s Decimal (19,4), or the Currency Data type in Power Pivot.

See Also

by 1 1 4
0 0
It's clear now! Thanks!
by 54 119 241
0 0
You are welcome, please don't forget to mark the asnwer as accpted in case it elped you!
If you don’t ask, the answer is always NO!