From the course: Power BI: Integrating AI
Unlock this course with a free trial
Join today to access over 24,800 courses taught by industry experts.
Building DAX models - Power BI Tutorial
From the course: Power BI: Integrating AI
Building DAX models
- [Instructor] Within our Power BI semantic model, DAX plays an important role in helping us build the calculations that we want. DAX, short for data analysis expressions, is a language that enables us to create formulas with functions, operators, and values for building advanced calculations within our tabular data model. DAX formulas produce tables, columns, and measures as their outputs from the input formulas that we put into them. In particular, DAX measures are one of the most important and impactful ways to build more advanced models in Power BI. Measures are portable dynamic DAX calculation formulas whose results change depending on the filter context in which we're evaluating them. I recommend trying to organize your measures within your semantic model. I'm going to do this by creating a measures group. We'll do so by entering data into our model in a blank table. We'll rename this new table calculations, and load it without anything other than the blank column one field into…
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.
Contents
-
-
-
-
(Locked)
Choosing Power BI visuals5m 48s
-
Leveraging slicers3m 28s
-
(Locked)
Defining dimensionality5m 32s
-
(Locked)
Building DAX models4m 39s
-
(Locked)
Using CALCULATE for DAX measures3m 29s
-
(Locked)
Visualizing distributions5m 17s
-
(Locked)
Leveraging parameters4m 54s
-
(Locked)
Formatting measure units5m 3s
-
(Locked)
-
-
-
-
-