Number.Power
A number multiplied by itself a number of times: x to the power of y.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.Power(number as nullable number, power as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The base. |
power | nullable number | The exponent; a fraction gives a root, a negative number one over the power. |
Returns
nullable number. The number raised to the power; null when either is null.
Examples
A thousand
Number.Power(10, 3)1000Interest compounded for three years
1,000 at 4 % a year.
Number.Round(1000 * Number.Power(1.04, 3), 2)1124.86A power of one half is a square root
Number.Power(9, 0.5)3