A constant value is a value that does not change. The M language provides a variety of such values to help with your data manipulation tasks.
Available Constants
Power Query offers the following constant values:
| Argument | Description |
|---|---|
| Number.E | A constant value in the Power Query M language that represents 2.7182818284590451. The number e (also known as Euler’s number) is specified with 16 decimal digits in the M language. |
| Number.Epsilon | A constant value in the Power Query M language that represents the smallest positive number a floating-point number can hold. |
| Number.NaN | A constant value in the Power Query M language that represents “Not-a-Number” (NaN). It is the result of dividing 0 by 0. The value is commonly used to indicate an indeterminate or undefined numeric result. Number. |
| Number.NegativeInfinity | A constant value in the Power Query M language that represents a number that is infinitely large or unbounded. It is commonly encountered in situations where operations result in dividing a negative nonzero number by zero. The Number. |
| Number.PI | A constant value in the Power Query M language that represents 3.1415926535897932, the value for pi up to 16 decimal digits. |
| Number.PositiveInfinity | A constant value in the Power Query M language that represents a number that is infinitely large or unbounded. It is commonly encountered in situations where operations result in dividing a nonzero number by zero. The Number. |
2023-2026 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy