Microsoft Data & Power BI
Introduction to DAX for Power BI
Learn DAX, the formula language of Power BI.
2 daysFoundation6 modules
About this course
Learn DAX, the formula language of Power BI. Over two days you will understand syntax and data types, create calculated columns, measures and tables, master context and write more advanced calculations.
What you'll learn
- Describe DAX syntax, data types, and errors
- Use DAX to create calculated columns, measures, and tables
- Explain how DAX calculations are evaluated, along with the differences between row context and filter context
- Configure and use Time Intelligence to perform common time-based calculations, for example to-date calculations, year-over-year analysis, moving averages, etc.
- Create calculated columns and measures that use data from multiple tables in the data model
- Write measures that handle error conditions gracefully
- Use DAX to enhance the Power BI user experience
- Use DAX Studio to connect to a Power BI data model and execute simple queries
Curriculum
6 modules
- Introduction to DAX
- Creating objects with DAX
- Context and rules of evaluation
- Variables, comments, and testing
- Getting started with calculations
- Implicit measures and adding quick measures
- Working with DAX data types and basic math
- Using logic in calculations: IF(), nested IF(), SWITCH(), advanced SWITCH(), logical operators and functions (OR(), AND(), NOT())
- Aggregating and summarizing data with the SUM() function
- Understanding context, data modeling basics, and dimensional modeling
- Relationships and their effect on the evaluation context
- Getting data from other tables: using RELATED(), RELATEDTABLE(), and looking up data without relationships
- Modifying context using CALCULATE()
- DAX iterator functions
- Table manipulation functions
- Performing date calculations and working with date tables
- Generating a date table with CALENDAR()
- Defining custom operating periods
- YTD, QTD, MTD, and custom to-date calculations
- Finding year-over-year change and moving averages
- Controlling measure visibility
- Using what-if parameters and adding banding
- Providing row-level security using DAX
Who it's for
Power BI users ready to write their own calculations.
Before you start
- Introduction to Power BI, Power BI: Hands-On Reports and Dashboards, Power BI: Advanced Data Modeling and Shaping or equivalent working experience.
Related courses
More in Microsoft Data & Power BI →IntermediateDP-605
DP-605 Prepare and visualize data with Microsoft Power BI
Microsoft Data & Power BI
View course →Intermediate
Power BI: Dashboard in a Day
Microsoft Data & Power BI
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.