Course
DAX Functions in Power BI
Create Your Free Account
Continue with GoogleShow more optionsor
Loved by learners at thousands of companies
Training a Team?
Try for BusinessCourse Description
Master DAX
DAX, or Data Analysis eXpressions, is a formula language used in Microsoft Power BI to create calculated columns, measures, and custom tables. Once mastered, DAX gives you powerful control over visuals and reports, allowing for better performance and more flexibility.Apply Context
This course covers the core concepts such as row query and filter context, with exercises focusing on filtering, counting, ranking, and iterating functions.What you'll learn
- Determine how filter context and relationships affect DAX calculations.
- Identify how to create and manage DAX measures used in report analysis.
- Identify the appropriate DAX function to create calculated tables or columns.
- Identify the correct aggregation or counting function to summarize data in DAX.
Feels like what you want to learn?
Start Course for FreePrerequisites
Introduction to DAX in Power BIData Modeling in Power BISetting up Data Models with DAX
DAX and Measures
Filtering and Counting with DAX
Iterating Functions
Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
Do I need prior DAX experience to take this course?
No. Chapter 1 introduces the fundamentals of DAX, including row, query, and filter context, so you can start without previous DAX knowledge. Basic familiarity with Power BI is recommended.
What DAX functions will I learn in this course?
You will learn functions for creating calculated tables and columns, writing measures with variables, filtering with CALCULATE and ALL, counting, ranking with RANKX, and using iterating functions.
What is the difference between calculated columns and measures in DAX?
Calculated columns are evaluated row by row and stored in the data model. Measures are evaluated dynamically based on the filter context of a visual. Chapter 2 covers when and why to use each approach.
What are iterating functions, and why are they useful?
Iterating functions evaluate an expression row by row across a table and then aggregate the results. Chapter 4 covers these functions, including how to use RANKX to rank data in your reports.
Who will benefit from this course?
Power BI users who want to move beyond drag-and-drop visuals and write custom calculations to gain more flexibility and control over their reports and dashboards.
Join over 19 million learners and start DAX Functions in Power BI today!
Create Your Free Account
Continue with GoogleShow more optionsor
Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.