Loved by learners at thousands of companies
Course Description
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. In this course, you'll get to grips with a wide range of DAX calculations and learn best practices for how to use them in your projects.
This course will be split into two smaller courses of 3 hours on Tue 26 April in light of a brand-new Power BI track. Course completion will be transferred to these two new courses, so please complete the course in due time. Alternatively, you can wait a few days until the new courses are live!
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more- 1
Setting up Data Models with DAX
FreeIn this chapter, you'll write custom functions to create new tables, calculated columns, and calculated measures. You'll also get introduced to variables to make writing DAX functions more efficient.
DAX for creating tables and columns50 xpRow vs. query vs. filter context100 xpDAX for calculated tables and columns50 xpCreating a date table100 xpCalculated column for costs100 xpData cleaning with DAX100 xpConnecting data from different tables100 xpMethods to create DAX measures50 xpAdvantages of explicit measures V2100 xpDAX and measures50 xpUsing variables100 xpBasic statistical measures100 xpQuick measures100 xp - 2
Common DAX Measures
Expand your DAX power with some commonly used DAX measures. This chapter covers the core concepts, with exercises focusing on filtering, counting, ranking, and iterating functions.
Filtering and counting with DAX50 xpUnderstanding different filter functions100 xpUsing different filters with DAX50 xpFilter ALL the data100 xpCalculating with a filter100 xpAnalyzing across dimensional tables100 xpIterating functions50 xpDIY iterating functions100 xpIterating functions in Power BI50 xpPractice with iterating functions100 xpMore iterating functions100 xpUse of RANKX()100 xp - 3
Refining DAX
In this chapter, you'll dive into logical functions! You’ll learn how to combine IF with other Power BI functions and discover the robust SWITCH function. Finally, you'll learn about row-level security, allowing you to change what data users see depending on their roles and permissions.
Logical functions50 xpInterpreting SWITCH()50 xpLogical functions in Power BI50 xpIF() for formatting tables100 xpExploring SWITCH()100 xpGrouping100 xpRow-level security50 xpApplying row-level security50 xpManaged roles in Power BI50 xpCreating an email list100 xpImplementing RLS100 xpSecurity filtering100 xp - 4
Advanced DAX
In this last chapter, you'll expand your DAX knowledge with two types of functions: table manipulation and time intelligence functions. You'll even explore a way to create advanced visuals without writing DAX.
Table manipulation functions50 xpSummary of SUMMARIZE()50 xpTable manipulations using DAX50 xpSUMMARIZE() the facts100 xpADDCOLUMNS()? No problem!100 xpTime intelligence functions50 xpTime intelligence functions output100 xpTime intelligence in Power BI50 xpUse of TOTALYTD()100 xpUse of SAMEPERIODLASTYEAR()100 xpBuild your own YoY quick measure100 xpDAX vs Q&A100 xpCongratulations!50 xp
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreCarl Rosseel
See MoreHead of BI Curriculum at DataCamp
Carl, a Tableau certified data analyst, is the head of the BI Curriculum at DataCamp, where he focuses on democratizing data skills through Business Intelligence tools. He holds a double master's degree in Business Engineering and worked in various analyst roles at an e-commerce company before joining DataCamp. He likes to use data to make the complex simple and tell data stories. Outside work, you can often find him enjoying a game of soccer, both on and off the pitch.
Maarten Van den Broeck
See MoreSenior Content Developer at DataCamp
Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. He is also a certified Power BI and Tableau data analyst. After his career as a PhD researcher at KU Leuven, he wished that he had discovered DataCamp sooner. He loves to combine education and data science to develop DataCamp courses. In his spare time, he runs a symphonic orchestra.
Join over 13 million learners and start 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.