POWER DAX Function (Math and Trig)

Syntax  |  Return values  |  Remarks  |  Examples  

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

Last update: Jan 31, 2023   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber,

Microsoft documentation: https://docs.microsoft.com/en-us/dax/power-function-dax