Use DAX in Power BI Desktop
5.0 /5- Offered byMicrosoft
Use DAX in Power BI Desktop at Microsoft Overview
Duration | 3 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Use DAX in Power BI Desktop at Microsoft Course details
- Describe Power BI Desktop models
- Write DAX formulas for Power BI Desktop models
- Add calculated tables and columns to Power BI Desktop models
- Add measures to Power BI Desktop models
- Use DAX iterator functions in Power BI Desktop models
- Modify DAX filter context in Power BI Desktop models
- Use DAX time intelligence functions in Power BI Desktop models
- Add DAX calculation groups to Power BI Desktop models
- Use DAX in Power BI Desktop to solve business problems
- This learning path introduces Data Analysis Expressions (DAX) and provides you with foundational skills required to enhance data models with calculations
- It starts by describing Power BI Desktop model structure and how it can be enhanced with DAX calculations
- It then describes how you can write DAX formulas and the different types of model calculations, including calculated tables, calculated columns, and measures
- Evaluation contexts are introduced, and subsequent lessons describe how to write DAX formulas that modify filter context
- Finally, you learn to write DAX expressions by using time intelligence functions and iterator functions
Use DAX in Power BI Desktop at Microsoft Curriculum
Describe Power BI Desktop models
Introduction
Star schema design
Analytic queries
Configure report visuals
Check your knowledge
Summary
Write DAX formulas for Power BI Desktop models
Introduction
Write DAX formulas
DAX data types
Work with DAX functions
Use DAX operators
Use DAX variables
Check your knowledge
Summary
Add calculated tables and columns to Power BI Desktop models
Introduction
Create calculated columns
Learn about row context
Choose a technique to add a column
Check your knowledge
Summary
Add measures to Power BI Desktop models
Introduction
Create simple measures
Create compound measures
Create quick measures
Compare calculated columns with measures
Check your knowledge
Summary
Use DAX iterator functions in Power BI Desktop models
Introduction
Use aggregation iterator functions
Calculate ranks
Check your knowledge
Summary
Modify DAX filter context in Power BI Desktop models
Introduction
Modify filter context
Use filter modifier functions
Examine filter context
Perform context transition
Check your knowledge
Summary
Use DAX time intelligence functions in Power BI Desktop models
Introduction
Use DAX time intelligence functions
Additional time intelligence calculations
Check your knowledge
Summary
Add DAX calculation groups to Power BI Desktop models
Introduction
Set up Tabular Editor 2
Create calculation groups
Work with other concepts
Check your knowledge
Summary
Use DAX in Power BI Desktop to solve business problems
Create an airline on-time performance report
Create calculations to scale measure values
Create calculations to dynamically classify products
Check your knowledge
Summary
Use DAX in Power BI Desktop at Microsoft Entry Requirements
- None
- Not mentioned
Use DAX in Power BI Desktop at Microsoft Admission Process
Important Dates
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?