Excel PowerPivot Level 2: DAX Measures & Calculations

Level 2Full Day1 DayVersion 365Official CPE Provider

Course Outline

6 lessons · 16 topics

1Build DAX Calculations for PowerPivot

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

2Improve Time Intelligence

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

3Duplicate 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

4Advanced DAX Functions

Handle Errors in DAX
Understand How Drop Zones Affect Measures
Respect and Ignore the Filters

5Use Variables in DAX

Learn Variable Syntax in DAX
Employ Variables in Measures

6Summarize Data using Time Intelligence

Create a Rolling Average
Create a Rolling Twelve Month Total

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals