713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


 

 


 

 
Excel In-Depth:
PowerPivot DAX Measures and Calculations
(PowerPivot Part 2)

Training Course Content (1 Day)

Course Objective: In this course, students will build on the skills learned in PowerPivot Part 1 by using calculations and measures to enhance PowerPivot reporting.

Prerequisites: PowerPivot Part 1 or equivalent knowledge is required prior to enrolling in class, as well as having a strong understanding of PivotTables, PivotCharts, Tables and the use of intermediate to advanced Excel functions.

Contact us to discuss if this class is right for you.

Lesson 1: Build DAX Calculations for PowerPivot

  • Create Calculated Columns and Measures
  • Understand DAX Formulas and Syntax
  • Summarize Data using SUMX, MINX, MAXX and AVERAGEX Functions

Lesson 2: Improve Time Intelligence Measures using DAX

  • Work with Time Dependent Data
  • Use the BLANK Function
  • Apply IF in DAX Measures
  • Create Measures using FIRSTDATE, LASTEDATE, ENDOFMONTH, STARTOFYEAR and DATESBETWEEN

Lesson 3: Duplicate Value Issues in Related Table Fields

  • Resolve Relationship Issues where a Many to Many is required
  • Merge Tables using PowerQuery
  • Manage and Refresh Tables created in PowerQuery

Lesson 4: Advanced DAX Functions

  • Handle Errors in Dax
  • Understand How Drop Zones Affect Measures
  • Respect and Ignore the Filters
  • Build Measures using ALL, ALLEXCEPT, ALLSELECTED, FILTER AND RANK

Lesson 5: Use Variables in DAX

  • Learn Variable Syntax in DAX
  • Employ Variables in Measures

Lesson 6: Summarize Data using Time Intelligence

  • Calculate an Ongoing Cumulative Total
  • Create a Rolling Average
  • Create a Rolling Twelve Month Total

Excel 365 Training Course Outlines

Excel 365 Core Features & Functions:

Excel 365 LV 1: Fundamentals of Excel
Excel 365 LV 2: Intermediate Functions & Features
Excel 365 LV 3: Advanced Tools &
Collaboration Features

Excel 365 LV 4: Advanced Functions

Excel 365 New Functions & Features:

Excel 365: New Functions & Formulas
Excel 365: New Features

Excel VBA Macros:

Excel 365 LV 5: Introduction To VBA Macros
Excel 365 LV 6: Advanced VBA Macros
 

Excel In-Depth Essentials:

Excel In-Depth: Charting Essentials
Excel In-Depth: PivotTable Essentials
Excel In-Depth: Advanced Excel Keyboarding

Excel Power Tools:

Excel Get & Transform (PowerQuery)
Excel PowerPivot Part 1
Excel PowerPivot Part 2

 

 

 
   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |