DAX On Power BI

This event has ended. You may view the recording here: DAX on Power BI

For full training, you may check it out here: Conquering DAX 2019

To read the blog about DAX:

1. Master The Art Of Learning Dax In 2022
2. Why DAX Is Underrated And Why You Should Learn?

WHAT YOU WILL LEARN

This one-day express training is designed to target participants with basic skills of Microsoft Power BI and extend them with the necessary knowledge of Data Analysis Expression (DAX). They will be able to learn how to create calculation elements in Power BI using the DAX language, such as calculated columns, measures, and calculated tables.

OBJECTIVES

After completing this workshop, participants will be able to:

• Understand the basic features of the DAX language

• Write formulas for common and slightly more advanced scenarios

PREREQUISITES

Attendees of this workshop are only required to have basic Microsoft Excel formulas knowledge and understand the basic functionalities of Microsoft Power BI.

COURSE CONTENTS

Module 1: Introduction to DAX

• What is DAX?

• Data types in DAX

• Calculated columns

• Measures

• Aggregate functions

• Logical functions

• Mathematical functions

• Variables

Module 2: Table Functions

• FILTER function

• ALL function

• ALLEXCEPT function

• DISTINCT function

• VALUES function

• ISEMPTY function

• RELATED/RELATEDTABLE functions

• Table relationships

Module 3: Contexts in DAX

• Evaluation contexts

• Filter contexts

• Row contexts

• Filtering many columns

• Filter arguments in CALCULATE

• FILTER and CROSSFILTER functions

• HASONEVALUE function

• ALLSELECTED function

Module 4: The Power of The CALCULATE Function

• Introduction to the CALCULATE function

• CALCULATE examples

• Filter is a table representative

• OR conditions in CALCULATE

• Clear filters on one column only

• Example: Ratios and Percentages

Note:

Complete the one-day FREE training and will receive a Certificate of Completion from us.