After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
Learn the DAX Fundamentals
Start your journey to becoming a DAX master with this introductory course on DAX. You’ll learn fundamental concepts and best practices for implementing DAX in your reports.Create Calcualted Columns, Measures and Tables
You’ll learn to write DAX code to generate calculated columns, measures, and tables while learning supporting knowledge around ‘context’ in Power BI. Finally, we’ll round off the course by introducing time-intelligence functions and show you how to use Quick Measures to create complex DAX code.Let’s take the first step in your DAX mastery journey!
Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Differentiate calculated columns, measures, and calculated tables by their calculation timing and impact on reports
- Distinguish between row context and filter context to predict results of DAX formulas
- Evaluate requirements for creating a dedicated date table and applying time-intelligence measures that rely on it
- Identify key DAX function categories and their correct syntax in Power BI
- Recognize appropriate scenarios for using iterator functions, variables, and the CALCULATE function to modify filter context
Prerequisites
Curriculum
Course outline
1
Getting Started with DAX
In this chapter, you’ll learn how to create custom calculations using Microsoft’s formula language, DAX (Data Analysis Expressions). You’ll learn how to expand your source tables with calculated columns, before progressing to writing calculated measures to help summarize your data.
2
Context in DAX Formulas
In this chapter, you'll learn about context in Power BI and how it plays an important part when building reports. Next, we'll learn how to use iterator functions to evaluate data at a row level. We'll then introduce you to the CALCULATE function to help you filter your data and finally, we'll show you how to use variables to make writing DAX functions more efficient.
3
Working with Dates
In this chapter, you'll learn the power of DAX's date and time intelligence functions. You'll be able to use these functions in actions, as well as use quick measures to create complex DAX code.
Introduction to DAX in Power BI
Course
Complete
