- Course
Create Model Calculations by Using DAX
The DAX modeling language allows complete control over the data in your visuals in Power BI. This course will teach you how to create new measures that filter and aggregate data in ways that are impossible without DAX.
Intermediate
- Course
Create Model Calculations by Using DAX
The DAX modeling language allows complete control over the data in your visuals in Power BI. This course will teach you how to create new measures that filter and aggregate data in ways that are impossible without DAX.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
The DAX modeling language allows for calculations in Power BI that are otherwise impossible using calculated columns and quick measures. In this course, Create Model Calculations by Using DAX, you’ll learn to enhance your Power BI reports with measures that can solve new problems like percentage of total calculations and end-of-quarter balances. First, you’ll explore how to replace existing measures with new DAX measures. Next, you’ll discover the CALCULATE formula, which will allow you to add and remove filters on your Power BI visuals. Finally, you’ll learn how to build measures that aggregate values over different time periods. When you’re finished with this course, you’ll have the skills and knowledge of the DAX modeling language needed to create advanced calculations in Power BI.
Create Model Calculations by Using DAX
Intermediate
Table of contents
Brent Allen is a finance and technology professional with an MBA from Queen's University and a CPA designation. He has built automated financial processes for large businesses using Excel, VBA and databases.