HomePower BIIntroduction to DAX in Power BI

# Introduction to DAX in Power BI

4.2+
150 reviews
Beginner

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

3 hours7 videos20 exercises

or

Training 2 or more people?Try DataCamp For Business

## 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!

### .css-1goj2uy{margin-right:8px;}Group.css-gnv7tt{font-size:20px;font-weight:700;white-space:nowrap;}.css-12nwtlk{box-sizing:border-box;margin:0;min-width:0;color:#05192D;font-size:16px;line-height:1.5;font-size:20px;font-weight:700;white-space:nowrap;}Training 2 or more people?

Try DataCamp for BusinessFor a bespoke solution book a demo.

### In the following Tracks

Certification Available

Go To Track

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.

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.

### In the following Tracks

Certification Available

Go To Track

#### Power BI Fundamentals

Go To Track

datasets

DataCamp vs. Local ExperienceExercises and Datasets

collaborators

Jess Ahmet

Content Developer at DataCamp

Jess is a Content Developer 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 150 reviews
55%
21%
16%
5%
3%
Sort by
• Nazanin K.
5 days

.

• edmund c.
17 days

Good, comprehensive

• Caroline B.

Relevant examples and exercises. I like it because the exercises are related to the examples given.

• Baguinebie B.
4 months

This course provide me skills to write Power BI scripts that are necessary to transform data before analysis

• Kamalika B.
4 months

the PowerBI sessions here are very in line with microsoft and fill in the gaps in a lot of ways other such tutorials dont. Better to take the advanced DAX right after this. What I love about DC is that tehy provide all resources as well as virtual access so that you can run it on MAC. only the VM PBI is outdated but nonetheless you can download the stuff on your local drive and try it on a windows laptop - all material is carefully curated and planned. I dislike video trainings but they have selected videos only when necessary and have more practice sessions with clear instructions than other MOOCs.

"."

Nazanin K.

"Good, comprehensive"

edmund c.

"Relevant examples and exercises. I like it because the exercises are related to the examples given."

Caroline B.