Search courses 👉
Professional Training
5.0 (6 Reviews)

DAX Introduction

Future Savvy, In London (+4 locations)
Length
2 days
Next course start
Enquire for more information (+4 start dates)
Course delivery
Classroom
Length
2 days
Next course start
Enquire for more information (+4 start dates)
Course delivery
Classroom
Leave your details so the provider can get in touch

Course description

DAX Introduction

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.

Upcoming start dates

Choose between 4 start dates

Enquire for more information

  • Classroom
  • Birmingham

Enquire for more information

  • Classroom
  • London

Enquire for more information

  • Classroom
  • Manchester

Enquire for more information

  • Classroom
  • Reading

Suitability - Who should attend?

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.

Training Course Content

Introduction to DAX

  • What is DAX?
  • Naming Requirements

DAX Syntax

  • Data Types
  • DAX Code Formatting
  • Rules & Guidelines

Basic DAX Functions

  • Basic Aggregators
  • Basic Iterators
  • COUNTROWS Function
  • DISTINCTCOUNT Function

Logical Functions

  • IF Function
  • SWITCH Function
  • AND Function
  • OR Function
  • IFERROR Function

Filter Functions

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

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

Information Functions

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

Relationship Functions

  • RELATED Function
  • RELATEDTABLE Function
  • USERELATIONSHIP Function

Time-Intelligence Functions

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

Other Useful Functions

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

Understand the Use of Parameter Tables

  • What-If Parameter
  • What if Parameter in Use

Creating Measures Using Variables

The DAX Studio Application Demonstration

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

Reviews

Average rating 5

Based on 6 reviews.
Reviews are published according to our review policy.
Write a review!
Kelly
5/5
01 Nov 2023

Amazing course content

Les
5/5
29 Sep 2023

Excellent course

Luke
5/5
08 Dec 2022

Excellent training session, excellent knowledgeable trainer

Request info

Contact form

Fill out your details to find out more about DAX Introduction.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Future Savvy

Welcome to Future Savvy, your gateway to a world of boundless learning and professional growth! At Future Savvy, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals...

Read more and show all courses with this provider

Ads