Course
Introduction to DAX in Power BI
Included withPremium or Teams
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training 2 or more people?
Try DataCamp for BusinessCourse 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
Introduction to Power BIGetting Started with DAX
Context in DAX Formulas
Working with Dates
Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance review
Included withPremium or Teams
Enroll NowFAQs
Is this course suitable for beginners?
Yes, this course is suitable for beginners. It is designed to teach you fundamental concepts and best practices for implementing DAX in Power BI reports.
Will I receive a certificate at the end of the course?
es, upon completion of this course you will receive a digital certificate of completion.
Who will benefit from this course?
Job roles such as Business Intelligence analysts and Power BI developers that need to create sophisticated Power BI reports would benefit from this course.
What topics will be covered in this course?
The topics covered in this course include getting started with DAX, understanding context in DAX formulas, and working with dates.
What is the CALCULATE function used for?
The CALCULATE function is used to filter your data and modify existing calculations according to certain criteria.
What are iterator functions?
Iterator functions are used to evaluate data at a row level and are often combined with the CALCULATE function.
What are Quick Measures?
Quick Measures are a feature in Power BI that allow you to create complex DAX code quickly and easily.
Join over 19 million learners and start Introduction to DAX in Power BI today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.