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

Unlock the full course today

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

DIVIDE DAX function

DIVIDE 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

DIVIDE DAX function

“

- [Instructor] Another powerful DAX function is the DIVIDE function, which works very similarly to divide operator as a forward slash, except it gives us the option to add an alternative result for an undefined calculation. This function also makes division calculations cleaner and easier to read. Furthermore, it also has a better performance in DAX models than the division operator because it leverages the built-in efficiencies of Power BI. There are three parts to the DIVIDE function. The first part is the numerator. The second part is the denominator. And the third part is the alternative result for the measure to return if the numerator divided by the denominator returns an undefined result. The payment amount is going to be the same for each month in the loan model we're building in Power BI, assuming that we have a fixed interest rate over the entire course of the loan, which we do. The payment amount equals…

Contents