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. 

Introduction to DAX in Power BI

Options

Calculated column

Calculated measure

Calculated columns vs. measures

Creating calculated columns and measures

Profit column

Sales count

Profit margin ratio

Getting Started with DAX

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.

Context in DAX formulas

The importance of Context

Creating DAX measures

Using variables

Iterator functions

Sales by category and year

Context in DAX Formulas

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.

The Date table

Creating a calculated table

Dates and Quick Measures

Expanding the Date table

DATEDIFF

Your first quick measure

Congratulations!

Working with Dates 

DataCamp vs. Local Experience

Exercises and Datasets

Course Glossary

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

The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos.

The course glossary can be found on the right in the resources section.

To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

<h2>Learn the DAX Fundamentals</h2>
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. 
<br><br>
<h2>Create Calcualted Columns, Measures and Tables</h2> 
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. 
<br><br>
Let’s take the first step in your DAX mastery journey!


Introduction to Power BI

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

Data Analyst in Power BI

Power BI Fundamentals

Stored in memory; pre-calculated and appended to each row in a table and stored inside the data model

`Revenue` and `Cost` are two columns in your table. `Profit = Revenue - Cost` is an example of a ____.

Not stored in memory; Makes use of CPU and is re-calculated each time a filter/slicer changes. 

Evaluated based on the set of data selected i.e. filters and slicers being applied in the report. 

Calculated columns vs. measures

Introduction to DAX in Power BI

Latihan interaktif praktis