Learning DAX with PowerBI
- Course Code M-DAX
- Duration 1 day
Course Delivery
Jump to:
Course Delivery
This course is available in the following formats:
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopEvery Power BI user who needs to add analytical power to a Power BI model not available in the data as-is requires DAX skills. DAX is not a language that can be learned by just starting in practice and building from there; theoretical knowledge is a requirement! That is why this 1 day training is offered. Questions like “when do I use a calculated column, when do I use a measure?”, “how does row- and filter context work exactly?”, “How do I create a table in DAX”, and much more. All parts of the DAX language that are required to be able to write DAX will be covered, including sufficient exercises in order to obtain hans-on experience.
Course Schedule
TopTarget Audience
TopEveryone who performs data analysis, including: Risk Managers, Financials, Analysts, Controllers, HR-Advisors, Customer Journey Experts, etc
Course Objectives
TopLearn to:
- Decide when to use a measure and when to use a calculated column
- Aggregate a column in a measure
- Aggregate an expression in a measure
- Use the different groups of functions within DAX
- Create relationships between tables
- Filter a table by another table
- Use normal -and bidirectional filtering
- Apply table functions
- Understand the difference between row- and filter context
- Ignore filter context using ALL
- Use variables in order to make DAX code easier to read
- Use variables in order to use the correct evaluation context
- Use CALCULATE in order to manipulate the filter context
- Use CALCULATE in order to trigger evaluation context transition
- Use Semi-Additive measures to adjust the summative filter context
- Use Time Intelligence functions
- Set up and Use Row-Level-Security to ensure the highest level of security on your data
Course Content
Top- Decide when to use a measure and when to use a calculated column
- Aggregate a column in a measure
- Aggregate an expression in a measure
- Use the different groups of functions within DAX
- Create relationships between tables
- Filter a table by another table
- Use normal -and bidirectional filtering
- Apply table functions
- Understand the difference between row- and filter context
- Ignore filter context using ALL
- Use variables in order to make DAX code easier to read
- Use variables in order to use the correct evaluation context
- Use CALCULATE in order to manipulate the filter context
- Use CALCULATE in order to trigger evaluation context transition
- Use Semi-Additive measures to adjust the summative filter context
- Use Time Intelligence functions
- Set up and Use Row-Level-Security to ensure the highest level of security on your data
Course Prerequisites
TopBasic knowledge of Power BI. The M-DA100 would fufill the basic requirements. Some previous DAX experience is nice-to-have but not a requirement.
Recommended prerequisites:
Test Certification
Top- /en-be/-/media/global-knowledge/rte-images/social-share/certifyforsuccess_button.png /en-be/certifications/certification-training/microsoft/certify-for-success #000000
- M-DAX
- Learning DAX with PowerBI
- Business Analysis
- M-DAX, Introduction to DAX | Global Knowledge
- Microsoft