Number.PositiveInfinity

Updated on

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.

Examples

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.

Related constants

Other related constants are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/number-positiveinfinity

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy