POWER DAX Function (Math and Trig)
Returns the result of a number raised to a power.
Syntax
POWER ( <Number>, <Power> )
| Parameter | Attributes | Description |
|---|---|---|
| Number |
The base number. |
|
| Power |
The exponent, to which the base number is raised. |
Return values
Scalar A single decimal value.
The Number raised to Power.
Remarks
The exponentiation operator ^ returns the same result as the POWER function.
The following two expressions are equivalent.
5 ^ 4 POWER ( 5, 4 )
Examples
-- SQRT computes the square root of a number
-- POWER raises the number to the required power
DEFINE
VAR Vals = GENERATESERIES ( 1, 25, 3 )
EVALUATE
ADDCOLUMNS (
Vals,
"SQRT", SQRT ( [Value] ),
"POWER (0.5)", POWER ( [Value], 0.5 ),
"POWER (4)", POWER ( [Value], 4 ),
"POWER -1", POWER ( [Value], -1 )
)
| Value | SQRT | POWER (0.5) | POWER (4) | POWER -1 |
|---|---|---|---|---|
| 1 | 1.00 | 1.00 | 1 | 1.00 |
| 4 | 2.00 | 2.00 | 256 | 0.25 |
| 7 | 2.65 | 2.65 | 2,401 | 0.14 |
| 10 | 3.16 | 3.16 | 10,000 | 0.10 |
| 13 | 3.61 | 3.61 | 28,561 | 0.08 |
| 16 | 4.00 | 4.00 | 65,536 | 0.06 |
| 19 | 4.36 | 4.36 | 130,321 | 0.05 |
| 22 | 4.69 | 4.69 | 234,256 | 0.05 |
| 25 | 5.00 | 5.00 | 390,625 | 0.04 |
Related articles
Learn more about POWER in the following articles:
-
Using EXPAND and COLLAPSE in visual calculations
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. » Read more
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,
Microsoft documentation: https://docs.microsoft.com/en-us/dax/power-function-dax
2018-2024 © SQLBI. All rights are reserved. Information coming from Microsoft documentation is property of Microsoft Corp. » Contact us » Privacy Policy & Cookies