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.

DAX quick measures

DAX quick measures - 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 quick measures

“

- [Instructor] DAX Quick Measures are a capability of Power BI to write DAX measures for us. This can potentially save time and increase efficiency because we don't have to write the formulas out ourselves. Conversely, quick measures are available for limited calculation types. They also might not work as we expect them to in our Power BI model. Quick measure categories include the aggregate per category, filters, time intelligence, and totals. Let's create a rolling average for the 30-year fixed mortgage rate. We'll use the page in Power BI where we already have the interest rate listed by date. We'll convert the date hierarchy that includes the year and month into a single date field. We can add the average measure from the 30-year interest rate to this table from Model 1 which matches the results for the 30-year fixed rate aggregated as an average. We'll remove the 15 and 30-year fixed rates from the table. Next, we'll…

Contents