# GRC-102FT - Conquering DAX 2019 - Fast Track

This workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language. This course covers the latest version of DAX 2019.

Duration: 3.0 days

Start learning today!

## Objectives

After completing this course, students will be able to:
• Understand all the features of the DAX language
• Write formulas for common and advanced scenarios

## Content

Module 1:Introduction to DAX
• What is DAX?
• DAX data types
• Calculated columns
• Measures
• Aggregation functions
• Counting values
• Conditional functions
• Handling errors
• Using variables
• Mathematical functions
• Relational functions

Module 2:Table Functions
• Introduction to table functions
• Filtering a table
• Ignoring filters
• Mixing filters
• DISTINCT Function
• How many values for a column?
• ALLSELECTED function
• RELATEDTABLE function
• Tables and relationships
• Tables with one row and one column
• Table variables

Module 3:Evaluation Contexts
• Introduction to evaluation contexts
• Filter context
• Row context
• Context errors
• Filtering a table
• Using RELATED in a row context
• Ranking by price
• Evaluation contexts and relationships
• Filters and relationships

Module 4:CALCULATE Function
• Introduction to CALCULATE function
• CALCULATE function examples
• CALCULATE function recap
• What is a filter context?
• KEEPFILTERS function
• CALCULATE operators
• Use one column only in a compact syntax
• Variables and evaluation contexts

Module 5:Iterators
• Working with iterators
• MINX and MAXX functions
• Useful iterators
• RANKX function
• ISINSCOPE function

Module 6:Time Intelligence in DAX
• What is time intelligence?
• Time intelligence functions
• DATESINPERIOD function
• Running total
• Mixing time intelligence functions
• Calculation over weeks

Module 7:Hierarchies in DAX
• What are hierarchies?
• FILTER and CROSSFILTER function
• Percentages over hierarchies
• Parent-child hierarchies
Module 8:ALLSELECTED and Shadow Filter Contexts
• ALLSELECTED function revisited

Module 9:Segmentation
• Static segmentation
• Circular dependency in calculated tables
• Dynamic segmentation

Module 10:Many-to-many Relationships
• How to handle many-to-many relationships
• Bidirectional filtering
• Expanded table filtering
• Comparison of the different techniques
Lab Exercises:

• Lab 01
o First steps with DAX
o Average sales per customer
o Average delivery time
o Last update of customer
o Working days
o Discount categories

• Lab 02
o Percentage of sales
o Delivery working days
o Sales of products in the first week
o Customers with children

• Lab 03
o Nested iterators
o Customers in North America (BASIC)
o Create a parameter table

• Lab 04
o Sales of red and blue products
o Understanding CALCULATE
o Sales of blue products
o Customers in North America (ADVANCED)
o Computing percentages

• Lab 05
o Correct sales of grey products
o Best customers
o Large sales
o Percentage of customers
o Counting spikes

• Lab 06
o Ranking customers (static)
o Ranking customers (dynamic)
o Date with the highest sales
o Moving average

• Lab 07
o Running total
o Comparison YOY%
o Sales in the first three months

• Lab 08
o Distinct count of countries
o Sales quantity greater than two

• Lab 09
o Static segmentation
• Lab 10
o Many-to-many relationships

N/A

## Prerequisites

Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling.

## Course Benefits

• Career growth
• Up-to Date technical skills

## ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

## sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

## az-204

Learn to create end-to-end solutions in Microsoft Azure in this 5-days official Microsoft course.

## az-104

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, co

OvWGYG