POWER Function (DAX)

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 Blog Posts

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.

Related Video Tutorials

Formula examples using the POWER function

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

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

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

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide