Number.PositiveInfinity is 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.PositiveInfinity constant is useful for handling extreme cases, outliers, or representing unbounded values in mathematical models and data analysis scenarios.
To access the constant value representing positive infinity in Power Query, you can simply call the Number.PositiveInfinity function without using any parentheses. This direct approach allows you to retrieve the symbol for positive infinity:
Number.PositiveInfinity // Returns ∞
When performing a division operation with a positive nonzero number divided by zero, Number.PositiveInfinity is the result:
20 / 0 // Returns ∞ (Positive Infinity)
The constant value produced by Number.PositiveInfinity can be used in boolean expressions as well. For example, you can check if the result of a division operation is equal to Number.PositiveInfinity:
( 20 / 0 ) = Number.PositiveInfinity // Returns TRUE ( 20 / 0 ) = ∞ // Returns an error, the M language does not accept the ∞ symbol
It’s important to note that while you can compare the result to Number.PositiveInfinity, the Power Query M language does not accept the symbol “∞” directly in expressions.
Other related constants are: