Background (2).png

DAX on Power BI

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


Related Course




Promotion





Dynamics 365