Number.E is 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. This constant can be used in mathematical computations, such as calculating continuous growth or decay, determining compound interest, or programming computations involving Euler’s number.
To retrieve the constant value of Euler’s number (e) in Power Query, you can simply call the Number.E function without using any parentheses. This direct approach allows you to obtain the 16 decimal value of the mathematical constant:
Number.E // Returns 2.7182818284590451
To get a better understanding of when Euler’s number is used, here are two examples.
Continuous growth or decay: Euler’s number is widely used to model continuous growth or decay in various fields, such as population growth, radioactive decay, or financial modeling. For example, you can use Euler’s number to calculate the future value of an investment with continuous compounding:
FutureValue = Principal * Number.Power( Number.E, Rate * Time )
Compound interest: Euler’s number is instrumental in compound interest calculations. You can use it to determine the future value of an investment compounded annually, quarterly, or with any other frequency:
Principal * Number.Power( 1 + Rate / Frequency, Frequency * Time )
Other related constants are: