DAX Introduction

Course Information

Overview

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, and at Analysis Services developers that want to learn and master the DAX language.

The goal of the course is to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios.

Prerequisites

You should be a competent Microsoft Excel user. You don’t need any experience of using DAX but we recommend that you attend our 2-day Microsoft Power BI Introduction course prior to taking this course.

1. Introduction to DAX

What is DAX?
Naming Requirements

2. DAX Syntax

Data Types
DAX Code Formatting
Rules & Guidelines

3. Basic DAX Functions

Basic Aggregators
Basic Iterators
COUNTROWS Function
DISTINCTCOUNT Function

4. Logical Functions

IF Function
SWITCH Function
AND Function
OR Function
IFERROR Function

5. Filter Functions

Introduction Evaluation, Row & Filter contexts
FILTER Function
CALCULATETABLE Function
CALCULATE Function

6. Date & Time Functions

CALENDAR Function
CALENDARAUTO() Function
DATE Function
DATEVALUE Function
YEAR Function
MONTH Function
WEEKDAY Function
WEEKNUM Function
FORMAT Function
EDATE Function
NOW Function
TODAY() Function
DATEDIFF Function

7. Information Functions

Information Functions Overview
HASONEVALUE Function
ISFILTERED Function
ISINSCOPE Function
USERNAME Function
USERPRINCIPALNAME Function

8. Relationship Functions

RELATED Function
RELATEDTABLE Function
USERELATIONSHIP Function

9. Time-Intelligence Functions

SAMEPERIODLASTYEAR Function
DATEADD Function
LASTDATE Function
DATESMTD/DATESQTD/DATESYTD Functions
TOTALMTD, TOTALQTD, TOTALYTD Functions
Other Time Intelligence Semi-Additive Measures

10. Other Useful Functions

DIVIDE Function
RANKX Function
ALL Function
ALLSELECTED Function
VALUES Function
SUMMARIZE Function
DATATABLE Function

11. Understand the Use of Parameter Tables

What-If Parameter
What if Parameter in Use

12. Creating Measures Using Variables

13. The DAX Studio Application Demonstration

What is DAX Studio
Format DAX Calculations in DAX Studio
Evaluate a Calculation in DAX Studio

Private Courses

We can arrange your own private Power BI course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:

At Your Offices

Virtual Online

Training Centres

What Our Clients Think

Course was well adjusted to consider the business perspective - considering commonly needed calculations, time based data analysis etc.

Suvi Salminen - Crane CPE

The trainer demonstrated a deep and knowledgeable understanding of the software and was able to simplify its complexities.

Nathan Lewis - Lincolnshire County Council

The trainer was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

Marianne Seager - Wincanton

Very good course. I've been using the software constantly in the last three months and still learnt a lot.

George Martin - NHS North of England

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

Very clear instruction, pace was kept moving, great snippets of advice given.

Robert Montgomery - Liberty Aluminium Technologies

Related Courses

Power BI Introduction

Introduction 2 Days

This Introduction course is designed for those looking to create interactive dashboards, charts and range visualizations that display data in a user-friendly way.

View Course