From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Unlock the full course today

Join today to access over 24,600 courses taught by industry experts.

POWER DAX function

POWER DAX function - Power BI Tutorial

From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Start my 1-month free trial Buy for my team

POWER DAX function

“

- [Instructor] In DAX, there's a carrot symbol that we can use to raise a value to a power. The Power DAX function, though, makes calculations cleaner and more efficient, especially for more complex formulas. The power function consists of two required inputs. The first parameter is the base value and the second parameter is the value we want to raise the base value to. For example, the power function with two as the base and three as the exponent is equal to raising two to the third power, which equals eight. Often when we are quoted loan interest rate, we are given the annual rate, but the payments are on a monthly basis. In order to get the monthly rate to be used in our loan calculations, we need to convert the annual rate into a monthly rate. The formula to convert this rate is one plus the annual interest rate all raised to the power of one divided by 12. The one is subtracted at the end to convert this…

Contents