Skip to main content

DAX in Power BI

Data Analysis Expressions (DAX) allow you to take your Power BI skills to the next level by writing custom functions.

Start Course for Free
6 Hours17 Videos50 Exercises6,313 Learners
4000 XP

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. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

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.

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

Datasets

DAX cheat sheetExercises and Datasources

Collaborators

Sara BillenLuke BarousseLis Sulmont
Maarten Van den Broeck Headshot

Maarten Van den Broeck

Content Developer at DataCamp

Maarten is an aquatic ecologist and teacher by training and a data scientist by profession. After his career as a Ph.D. 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
Carl Rosseel Headshot

Carl Rosseel

Curriculum Manager at Datacamp

Carl is a Curriculum Manager 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 create visualizations to tell data stories. Outside work, you can often find him enjoying a game of soccer, both on and off the pitch.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA