request@systematix.co.uk
supermarketBasket
Call Us On:
0118 324 3000

Exciting News! Systematix is rebranding to Future Savvy. Same great services, with a fresh new look. Learn More

banner image

DAX Introduction

2 Day Instructor-led
course icon

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.

Course Outline

Download PDF Outline
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

Dates & Prices

Attend one of our public Power BI courses:

Small Class Sizes

Maximum of 6 students per course.

Reference Manual

High quality reference manual supporting the topics covered.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:
Virtual Online Virtual Online
Choose a location...
2 Day Course
Thu, 26 Sep 2024 to Fri, 27 Sep 2024
Virtual
£795
Thu, 28 Nov 2024 to Fri, 29 Nov 2024
Virtual
£795
Thu, 19 Dec 2024 to Fri, 20 Dec 2024
Virtual
£795
Wed, 22 Jan 2025 to Thu, 23 Jan 2025
Virtual
£795
Wed, 26 Feb 2025 to Thu, 27 Feb 2025
Virtual
£795

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:
On-Site At Your Offices
Virtual Online Virtual Online
Training Centres Training Centres

What Our Clients Think

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

Nathan Lewis - Lincolnshire County Council

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

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

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 good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

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

Suvi Salminen - Crane CPE

Related Courses

Next on Mon 21 Oct

Power BI Introduction

Format:
Virtual or Classroom
Length:
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.
Next on Fri 25 Oct

Power BI Intermediate

Format:
Virtual or Classroom
Length:
1 Day
On this course you will learn how to gather more insight from your data by using data slicers and drill down techniques.

Power BI Service Introduction

Format:
Virtual or Classroom
Length:
1 Day
This one-day course focuses on importing data from a variety of sources, creating reports and configuring online interactive dashboard.
Next on Thu 26 Sep

DAX Introduction

Format:
Virtual or Classroom
Length:
2 Days
Learn to use DAX the native language of Power BI & Power Pivot and write formulas for common and advanced business scenarios.