Day 1

Introduction to DAX

• DAX basics
• What is DAX
• Dax data types
• Calculated Columns
• Measures

Introduction to DAX

• DAX basics
• What is DAX
• Dax data types
• Calculated Columns
• Measures
• Naming convention
• Measures Vs Calculated Columns
• Aggregate Functions
• Counting Values
• Logical functions
• The SWITCH Function
• Information Function
• MAX and MIN Function
• Divide Function
• Using Variables

Deep dive into CALCULATE

• Introduction to Calculate
• Understand the use of CALCULATE
• Calculate Examples
• Filters and Tables
• OR conditions in CALCULATE
• Clear filter on one column only
• CALCULATE Tasks

Table Functions

• Introduction to table functions
• FILTER Function
• ALL function
• ALLEXCEPT function
• Mixing filters
• DISTINCT function
• VALUES AND ALLNOBLANKROW functions
• ISEMPTY function
• RELATED TABLE function
• Tables and Relationships

Time intelligence functions

• MTD, QTD, YTD, SamePeriodLastYear
• YTD, MTD with CALCULATE
• Rolling totals for different periods
• IF, HasOneValue
• Using a Safe Divide Function
• Using the Blank() Function
• Build an Example Time Intelligence Report
• Creating Dynamic titles
• Using parameter table

Day 2

Evaluation Context and Relationships

• Introduction to evaluation contexts and relationships
• Row Context and Relationships
• Filter Context and Relationships
• CALCULATE Examples
• Filtering many columns
• FILTER AND CROSSFILTER Functions
• HASONEVALUE Function
• ALLSELECTED Function

Building a Date Table

• Introduction
• CALENDAR Function
• CALENDAR AUTO Function
• Mark as Date table
• Set sorting options
• Multiple Dates

Working with iterators

• Introduction to iterators
• Useful iterators
• MIN-MAX Sales per customer
• RANKX Function and examples

Dax Studio

• Capturing and debugging queries with Dax Studio
• Power BI referencing

Conclusion

• Summary

Our international certified trainers have highly experienced Microsoft Power BI practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed Microsoft PowerBI.

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376