Precision.Decimal (1) is an enumeration that specifies the precision of comparison. It is a member of the Precision.Type and represents an optional parameter for the built-in arithmetic operators to specify decimal precision.
Examples
Decimal precision is a 128-bit floating-point number with a higher precision and a smaller range compared to Double Precision. Because this method allows for more precise numbers, it has less rounding errors. For example, whereas precision decimal cannot understand 0.1 as exactly 1/10th of a value, Precision Double can.
If you need a higher precision, you can provide your functions with Precision.Decimal instead. For instance, the List.Sum function has a Precision Type parameter.
List.Sum( { 0.1, 0.1, 0.1 }, 1 ) // Returns 0,3
List.Sum( { 0.1, 0.1, 0.1 }, Precision.Decimal ) // Returns 0,3Compare this with the lower precision of Precision.Double:
List.Sum( { 0.1, 0.1, 0.1 } ) // Returns 0,30000000000000004
List.Sum( { 0.1, 0.1, 0.1 }, Precision.Double ) // Returns 0,30000000000000004The same happens for functions like Value.Add:
Value.Add( 0.2, 0.1 ) // Returns 0,30000000000000004
Value.Add( 0.2, 0.1, 1 ) // Returns 0,3
Value.Add( 0.2, 0.1, Precision.Decimal ) // Returns 0,3Related articles
Learn more about Precision.Decimal in the following articles:
- Power Query Precision: Avoid Rounding Errors
Learn how to handle precision differences in Power Query. With these tips you can return accurate numbers and prevent rounding errors. » Read more
Related enumerations
Other related enumerations are:
Applies to
Here’s a list of functions that work with Precision.Type:
- List.Average
- List.Product
- List.Sum
- Number.IntegerDivide
- Number.Mod
- Value.Add
- Value.Compare
- Value.Divide
- Value.Equals
- Value.Multiply
- Value.NullableEquals
- Value.Subtract
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy