Skip to main content

Home Power BIIntroduction to DAX in Power BI

Introduction to DAX in Power BI

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

Comece O Curso Gratuitamente

2 Horas7 Videos20 Exercicios

64.651 AprendizesDeclaração de Realização

Create Your Free Account

Google LinkedIn Facebook

or

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

Treinar 2 ou mais pessoas?Experimente o DataCamp For Business

Loved by learners at thousands of companies

Descrição do Curso

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!

Para Empresas

Treinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Nas seguintes faixas

Certificação disponível

Analista de dados no Power BI

Ir para a trilha

Fundamentos do Power BI

Ir para a trilha

1
Getting Started with DAX
Grátis
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.
Reproduzir Capítulo Agora
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
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.
Reproduzir Capítulo Agora
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
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.
Reproduzir Capítulo Agora
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

Para Empresas

Treinar 2 ou mais pessoas?

Obtenha acesso à biblioteca completa do DataCamp, com relatórios, atribuições, projetos e muito mais centralizados

Nas seguintes faixas

Certificação disponível

Analista de dados no Power BI

Ir para a trilha

Fundamentos do Power BI

Ir para a trilha

Conjuntos De Dados

DataCamp vs. Local Experience Exercises and Datasets

Colaboradores

Maarten Van den Broeck

Carl Rosseel

Pre Requisitos

Introduction to Power BI

Content Developer at DataCamp

O que os outros alunos têm a dizer?

Cadastre-se mais 13 milhões de alunos e comece Introduction to DAX in Power BI Hoje!

Create Your Free Account

Google LinkedIn Facebook

or

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