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.

DAX acrobatics

DAX acrobatics - Power BI Tutorial

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

Start my 1-month free trial Buy for my team

DAX acrobatics

“

- [Instructor] Getting DAX formulas especially for measures to work can require a bit of persistence and flexibility to make these DAX acrobatics work in Power BI. Let's explore how to apply DAX tricks using these calculations and our loan model. By calculating the average interest rate for a particular month compared to the fixed interest rate that we took the loan out over that maintains the same rate over the entire loan duration. Even though there are dates in the table we're adding our DAX measure calculations to. These aren't the same dates we find as those in the interest rates table containing the 30 year and 15 year fixed mortgage rates. We'll create a new measure for the average interest rate for the current month. We'll first calculate the current date from the table visual using the MAX function and we'll call this the start of the month, on the current date and the comments. Now let's filter the disconnected…

Contents