IT Skills     Data and Databases     Data Visualization     Design Data Models in Power BI

---

Power BI does the heavy lifting when it comes to analyzing data. One way it does this is through the DAX formula language. By learning how to use this language, you can vastly improve the insights you get from data.
Use this course to learn how to conduct several data analysis operations using the DAX formula language. Begin by performing aggregation operations, such as sum and average. Learn how to generate and work with blank data in DAX. Explore a variety of counting functions, ranging from simple counts of values to conditional counts based on filters. Lastly, practice using the IF and SWITCH functions.
Upon course completion, you'll know how to use DAX to calculate values and reference table data in Power BI. You'll also be further prepared for the DA-100: Analyzing Data with Microsoft Power BI certification exam.

---

---

Objectives

PL-300: Applying the DAX Formula Language in Power BI discover the key concepts covered in this course import multiple related tables into Power BI Desktop use the DAX language to calculate a sum of values based on an operation performed on raw data compute the average of a value derived from the data in a table use the BLANK function to generate blank values perform a variety of count operations using the different count functions available in DAX perform operations on a subset of data in a table define a DAX formula using nested IF function calls set the operations to be performed in different scenarios using the SWITCH function summarize the key concepts covered in this course