Constants Overview

Updated on

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:

ArgumentDescription
Number.EA 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.EpsilonA constant value in the Power Query M language that represents the smallest positive number a floating-point number can hold.
Number.NaNA 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.NegativeInfinityA 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.PIA constant value in the Power Query M language that represents 3.1415926535897932, the value for pi up to 16 decimal digits.
Number.PositiveInfinityA 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.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/constants
© 2024 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.