Skip to main content
HomePower BI

Introduction to DAX in Power BI

4.2+
159 reviews
Beginner

Enhance your Power BI knowledge, by learning the fundamentals of Data Analysis Expressions (DAX) such as calculated columns, tables, and measures.

Start Course for Free
3 hours7 videos20 exercises87,681 learnersTrophyStatement of Accomplishment

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

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course 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!
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Certification Available

Data Analyst in Power BI

Go To Track

Power BI Fundamentals

Go To Track
  1. 1

    Getting Started with DAX

    Free

    In this chapter, you’ll learn how to create custom calculations using Microsoft’s formula language, DAX (Data Analysis Expressions). You’ll learn how to expand your source tables with calculated columns, before progressing to writing calculated measures to help summarize your data.

    Play Chapter Now
    Introduction to DAX in Power BI
    50 xp
    Calculated columns vs. measures
    100 xp
    Creating calculated columns and measures
    50 xp
    Profit column
    100 xp
    Sales count
    100 xp
    Profit margin ratio
    100 xp
  2. 2

    Context in DAX Formulas

    In this chapter, you'll learn about context in Power BI and how it plays an important part when building reports. Next, we'll learn how to use iterator functions to evaluate data at a row level. We'll then introduce you to the CALCULATE function to help you filter your data and finally, we'll show you how to use variables to make writing DAX functions more efficient.

    Play Chapter Now
    Context in DAX formulas
    50 xp
    The importance of Context
    100 xp
    Creating DAX measures
    50 xp
    Using variables
    100 xp
    Iterator functions
    100 xp
    Sales by category and year
    100 xp
  3. 3

    Working with Dates

    In this chapter, you'll learn the power of DAX's date and time intelligence functions. You'll be able to use these functions in actions, as well as use quick measures to create complex DAX code.

    Play Chapter Now
    The Date table
    50 xp
    Creating a calculated table
    100 xp
    Dates and Quick Measures
    50 xp
    Expanding the Date table
    100 xp
    DATEDIFF
    100 xp
    Your first quick measure
    100 xp
    Year-over-year change
    100 xp
    Congratulations!
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Certification Available

Data Analyst in Power BI

Go To Track

Power BI Fundamentals

Go To Track

datasets

DataCamp vs. Local ExperienceExercises and Datasets

collaborators

Collaborator's avatar
Maarten Van den Broeck
Collaborator's avatar
Carl Rosseel

prerequisites

Introduction to Power BI
Jess Ahmet HeadshotJess Ahmet

Curriculum Manager at DataCamp

Jess is a Curriculum Manager at DataCamp. Prior to joining DataCamp, she worked in various analyst roles within healthcare and most recently online gambling. She has a passion for education, data, and business which she has been able to combine in her role at DataCamp. Outside of work, you can often find her in front of a TV watching Soccer and Formula 1.
See More

Don’t just take our word for it

*4.2
from 159 reviews
57%
20%
16%
4%
3%
Sort by
  • Bhupal M.
    7 days

    Thank you for the Introduction to DAX course! It gave me a solid foundation in using DAX for data analysis in Power BI, with clear examples and helpful exercises. I now feel more confident building insights and calculations in Power BI.

  • Richmond G.
    10 days

    QoQ% and YoY% exercises do not yield the right result as total sales data is the same throughout

  • Shubhanshu P.
    11 days

    Good content in just 3 hours. Learnt new things.

  • Cetin E.
    15 days

    Very good explanations

  • Christine R.
    2 months

    Thank goodness for the hints.

"Thank you for the Introduction to DAX course! It gave me a solid foundation in using DAX for data analysis in Power BI, with clear examples and helpful exercises. I now feel more confident building insights and calculations in Power BI."

Bhupal M.

"QoQ% and YoY% exercises do not yield the right result as total sales data is the same throughout"

Richmond G.

"Good content in just 3 hours. Learnt new things."

Shubhanshu P.

FAQs

Join over 15 million learners and start Introduction to 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.