From the course: Using Power BI with Excel
Join today to access over 24,700 courses taught by industry experts.
Introduction to DAX - Power BI Tutorial
From the course: Using Power BI with Excel
Introduction to DAX
- [Instructor] Power BI uses a formula expression language called DAX. DAX is short for Data Analysis Expressions and is a library of functions and operators that allow you to create formulas and expressions in Power BI. Now, DAX is pretty complex, but you really need to understand two key concepts of how Power BI uses DAX. The first concept is how to create a calculated column index. This skill will allow you to better understand how two fields are related. A calculated column will understand row context. This means that your equations will be calculated along the row and not aggregated. This is important to know, as calculated columns are immune to context filters. Next, you need to understand how DAX handles measures. Measures are DAX formulas used to create calculated values. Think sum, average, and count. These are the different ways you can measure your fields. Since measures are aggregated values, they will…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
