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.
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
Attendees of this workshop are only required to have basic Microsoft Excel formulas knowledge and understand the basic functionalities of Microsoft Power BI.
Module 1: Introduction to DAX
What is DAX?
Data types in DAX
Module 2: Table Functions
Module 3: Contexts in DAX
Filtering many columns
Filter arguments in CALCULATE
FILTER and CROSSFILTER functions
Module 4: The Power of The CALCULATE Function
Introduction to the CALCULATE function
Filter is a table representative
OR conditions in CALCULATE
Clear filters on one column only
Example: Ratios and Percentages