DAX Functions in Power BI

Offered byDataCamp

DAX Functions in Power BI
at
DataCamp
Overview

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

Duration	3 hours
Total fee	Free
Mode of learning	Online
Schedule type	Self paced
Official Website	Explore Free Course
Credential	Certificate

DAX Functions in Power BI
at
DataCamp
Highlights

Learn from 9 Videos and 26 Exercises

DAX Functions in Power BI
at
DataCamp
Course details

Skills you will learn

Data Modeling Statistics Data analysis

More about this course

This course covers the core concepts such as row query and filter context, with exercises focusing on filtering, counting, ranking, and iterating functions
Once mastered, DAX gives you powerful control over visuals and reports, allowing for better performance and more flexibility
DAX, or Data Analysis eXpressions, is a formula language used in Microsoft Power BI to create calculated columns, measures, and custom tables

DAX Functions in Power BI
at
DataCamp
Curriculum

Setting up Data Models with DAX

DAX for creating tables and columns

Row vs. query vs. filter context

DAX for calculated tables and columns

Creating a date table

Calculated column for costs

Data cleaning with DAX

Connecting data from different tables

DAX and Measures

Methods to create DAX measures

Advantages of explicit measures

DAX and Measures

Using variables

Basic statistical measures

Quick measures

Filtering and Counting with DAX

Filtering and counting with DAX

Understanding different filter functions

Using different filters with DAX

Filter ALL the data

Calculating with a filter

Analyzing across dimensional tables

Iterating Functions

Iterating functions

DIY iterating functions

Iterating functions in Power BI

Practice with iterating functions

More iterating functions

Use of RANKX()

Congratulations!

DAX Functions in Power BI
at
DataCamp
Faculty details

Maarten Van den Broeck

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.

Carl Rosseel

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.