## How does the POWER function (DAX) work?

The POWER function (DAX) returns the result of a number raised to a power.

## POWER Formula Syntax

POWER (
<number>, <power>
)

## How do you use the POWER function?

The POWER function can be used to raise a number to a given power. The POWER function works  like an exponent in a standard math equation. In Excel, exponentiation is handled with the caret (^) operator.

## Related Support Forum Posts

PowerApps and Power BI – Refresh data speed
Streaming Power BI with on-premises database through Powershell
Power BI Report Builder – Find User Name From Power BI Cloud

## Considerations when using the POWER function

To appreciate the variety of behaviors among members of the power family, consider two simple cases:

• Even powers.

If  b  is a an even whole number like  b = –2, 4, 10, etc., then for any input  x  we will have  f(–x) = a(–x)b = a(–1)b(x)b = a(x)b = f(x) , since  –1  raised to an even power is  1 . The function has a certain symmetry: Its outputs for any  x  are exactly the same as its outputs for  –x . We call any function with this behavior an even function, with even powers serving as the archetype.

• Odd powers.

If  b  is a an odd whole number like  b = –1, 3, 7, etc., then for any input  x  we will have  f(–x) = a(–x)b = a(–1)b(x)b = a(–1)(x)b = –f(x) , since  –1  raised to an odd power is  –1 . The function has a certain anti-symmetry: Its outputs for any  x  are exactly the opposite of its outputs for  –x  . We call any function with this behavior an odd function, with odd powers serving as the archetype.

The difference between odd and even powers only hints at the differences among power functions.

## Formula examples using the POWER function

2^2=POWER(2,2)=4

2^3=POWER(2,3)=8

2^4=POWER(2,4)=16