Excel DAX Formulas for Power Pivot Training Course

Table of Contents

Excel DAX Formulas for Power Pivot Course Overview

Our Excel DAX Formulas for Power Pivot is designed for those who need to create formulas using the Data Analysis Expressions language (DAX) to analyse Power Pivot data. DAX is the same formula language that is used in Microsoft Power BI. Although many DAX functions are similar to Excel the principles differ, in particular the evaluation context. The course includes a discussion of DAX Time Intelligence functions for calculating comparisons across different time periods.

Excel DAX formulas Five Key Topics

  1. Calculated columns and Measures
  2. DAX functions
  3. Mastering the CALCULATE function
  4. Time Intelligence functions
  5. Cube formulas

Excel DAX Formulas Course Details

Course Duration : 1 day
Course Availability : Monday – Saturday
Course Types : Group booking, 1-2-1 sessions, Bespoke & Public Courses
Training Times : Our courses run run from 09:30 to16:30, course registration 09:00 – 09:30, refreshments available throughout the day. A buffet lunch is available – please discuss with the team.
Facilities : A relaxed environment, air conditioned training rooms, note pads, pens and unlimited access to our online course materials.

Excel DAX Formulas for Power Pivot Course Details

Course Location : Face to face group / public & onsite training available. Virtual training courses available.

Class Size : As a guide we recommend class sizes to be no more than eight.

Virtual / Online training Format : Teams or Zoom.

Tailored Course Content : Our Excel DAX Formulas courses can be tailored to your requirements – Get In Touch

Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.

Centre and Services

Comfortable & modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

Our Trainers

Steve, one of our lead Excel trainers, has over 25 years of delivering Excel from basics to development levels. All our trainers are encouraged to become Microsoft Accredited within their first year of working at Mouse Training.

Our instructors are very approachable, making the driest subject matter fun. 

On Completion of Excel DAX Formulas for Power Pivot

  • Write and understand DAX formulas
  • Use DAX Aggregate functions
  • Understand the DAX evaluation context
  • Use DAX Date and Time functions
  • Use DAX Text functions
  • Use DAX Mathematical functions
  • Use DAX Time Intelligence functions

Excel DAX Formulas for Power Pivot Course Outline

  • Overview of creating the data model
  • Where to write DAX
  • Creating Calculated Columns
  • Creating Measures
  • Operators and Operator precedence
  • Data Types
  • SUM, AVERAGE, MIN, COUNT, COUNTA and MAX
  • Iterator functions: SUMX, AVERAGEX, MINX, COUNTX, COUNTAX and MAXX
  • Statistical functions
  • DIVIDE function
  • Understanding Evaluation Contexts and Relationships
  • Filter and Row Context
  • ALL function
  • ALLEXCEPT function
  • CALCULATE function
  • CALCULATETABLE function
  • RELATED function
  • RELATEDTABLE function
  • FILTER function
  • IFERROR function
  • DISTINCT function
  • EARLIER function
  • DATE function
  • HOUR function
  • MONTH function
  • YEAR function
  • DAY function
  • WEEKDAY function
  • WEEKNUM function
  • FORMAT function
  • CONCATENATE function
  • LEFT function
  • RIGHT function
  • TRIM function
  • SUBSTITUTE function
  • INT function
  • MOD function
  • ROUND function
  • ROUNDUP function
  • ROUNDDOWN function
  • Creating a Date dimension table
  • CLOSINGBALANCEMONTH function
  • CLOSINGBALANCEQUARTER function
  • CLOSINGBALANCEYEAR function
  • DATEADD function
  • DATESBETWEEN function
  • DATESINPERIOD function
  • DATESMTD function
  • DATESQTD function
  • DATESYTD function
  • ENDOFMONTH function
  • ENDOFQUARTER function
  • ENDOFYEAR function
  • FIRSTDATE function
  • FIRSTNONBLANK function
  • LASTDATE function
  • LASTNONBLANK function
  • NEXTDAY function
  • NEXTMONTH function
  • NEXTQUARTER function
  • NEXTYEAR function
  • OPENINGBALANCEMONTH function
  • OPENINGBALANCEQUARTER function
  • OPENINGBALANCEYEAR function
  • PARALLELPERIOD function
  • PREVIOUSDAY function
  • PREVIOUSMONTH function
  • PREVIOUSQUARTER function
  • PREVIOUSYEAR function
  • SAMEPERIODLASTYEAR function
  • STARTOFMONTH function
  • STARTOFQUARTER function
  • STARTOFYEAR function
  • TOTALMTD function
  • TOTALQTD function
  • TOTALYTD function
  • Convert an Excel Pivot Table to Cube formulas
  • Excel CUBEMEMBER and CUBEVALUE functions

Is this introduction Course for You?

Give us a call, our admin team will be delighted to assist in making sure you are on the correct course.

Excel DAX Hints & Tips