Number.Power

Number.Power is a Power Query M function that raises a given number to the power of another number. The function returns the result of the exponentiation or null if either the base or exponent are null.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Number.Power(
   number as nullable number,
   power as nullable number,
) as nullable number

Description

Returns the result of raising number to the power of power. If number or power are null, Number.Power returns null.

• number: The base.
• power: The exponent.

Examples

Find the value of 5 raised to the power of 3 ( 5 cubed ).

// Output: 125
Number.Power( 5, 3 )

Related functions

Other functions related to Number.Power are:

• Number.Abs
• Number.Combinations
• Number.Exp
• Number.Factorial
• Number.IntegerDivide
• Number.Ln
• Number.Log
• Number.Log10
• Number.Mod
• Number.Permutations
• Number.Sign
• Number.Sqrt

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