Skip to main content

Oksana Marets has completed

DAX in Power BI

Start course For Free
6 hours
4,000 XP
Statement of Accomplishment Badge

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

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Setting up Data Models with DAX

    Free

    In 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.

    Play Chapter Now
    DAX for creating tables and columns
    50 xp
    Row vs. query vs. filter context
    100 xp
    DAX for calculated tables and columns
    50 xp
    Creating a date table
    100 xp
    Calculated column for costs
    100 xp
    Data cleaning with DAX
    100 xp
    Connecting data from different tables
    100 xp
    Methods to create DAX measures
    50 xp
    Advantages of explicit measures V2
    100 xp
    DAX and measures
    50 xp
    Using variables
    100 xp
    Basic statistical measures
    100 xp
    Quick measures
    100 xp
  2. 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.

    Play Chapter Now
    Filtering and counting with DAX
    50 xp
    Understanding different filter functions
    100 xp
    Using different filters with DAX
    50 xp
    Filter ALL the data
    100 xp
    Calculating with a filter
    100 xp
    Analyzing across dimensional tables
    100 xp
    Iterating functions
    50 xp
    DIY iterating functions
    100 xp
    Iterating functions in Power BI
    50 xp
    Practice with iterating functions
    100 xp
    More iterating functions
    100 xp
    Use of RANKX()
    100 xp
  3. 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.

    Play Chapter Now
    Logical functions
    50 xp
    Interpreting SWITCH()
    50 xp
    Logical functions in Power BI
    50 xp
    IF() for formatting tables
    100 xp
    Exploring SWITCH()
    100 xp
    Grouping
    100 xp
    Row-level security
    50 xp
    Applying row-level security
    50 xp
    Managed roles in Power BI
    50 xp
    Creating an email list
    100 xp
    Implementing RLS
    100 xp
    Security filtering
    100 xp
  4. 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.

    Play Chapter Now
    Table manipulation functions
    50 xp
    Summary of SUMMARIZE()
    50 xp
    Table manipulations using DAX
    50 xp
    SUMMARIZE() the facts
    100 xp
    ADDCOLUMNS()? No problem!
    100 xp
    Time intelligence functions
    50 xp
    Time intelligence functions output
    100 xp
    Time intelligence in Power BI
    50 xp
    Use of TOTALYTD()
    100 xp
    Use of SAMEPERIODLASTYEAR()
    100 xp
    Build your own YoY quick measure
    100 xp
    DAX vs Q&A
    100 xp
    Congratulations!
    50 xp

Datasets

DAX cheat sheetExercises and Datasources

Collaborators

Collaborator's avatar
Sara Billen
Collaborator's avatar
Lis Sulmont
Collaborator's avatar
Luke Barousse

Prerequisites

Data Modeling in Power BI
Carl Rosseel HeadshotCarl Rosseel

Head 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.
See More
Maarten Van den Broeck HeadshotMaarten Van den Broeck

Senior 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.
See More

Join over 13 million learners and start DAX in Power BI today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.