Excel Solutions TeamComputer Training CenterExcel Training · Houston & Live Online
Excel PowerPivot Level 2: DAX Measures & Calculations
Go deeper into DAX in Excel PowerPivot. Build advanced calculated columns and measures, use SUMX and time-intelligence functions, fix tricky relationships with Power Query, and create rolling averages and running totals.
Course Objective
Students will build DAX calculations in Excel PowerPivot, including calculated columns and measures, time-intelligence functions, and variables, resolve relationship issues with Power Query, and create rolling averages and running totals.
Prerequisites
To ensure your success, we recommend that you have experience with Excel PivotTables and an introduction to PowerPivot and the data model. Students can obtain this level of skill through our Excel PowerPivot course. Contact us to discuss if this class is right for you.
Course Outline
6 lessons · 16 topics- Create Calculated Columns and Measures
- Understand DAX Formulas and Syntax
- Summarize Data using SUMX, MINX, MAXX, and AVERAGEX Functions
- Work with Time Dependent Data
- Use the BLANK Function and Apply IF in DAX Measures
- Create Measures using FIRSTDATE, LASTDATE, ENDOFMONTH, STARTOFYEAR and DATESBETWEEN
- Resolve Relationship Issues where a Many to Many is required
- Merge Tables using PowerQuery
- Manage and Refresh Tables created in PowerQuery
- Handle Errors in DAX
- Understand How Drop Zones Affect Measures
- Respect and Ignore the Filters
- Learn Variable Syntax in DAX
- Employ Variables in Measures
- Create a Rolling Average
- Create a Rolling Twelve Month Total
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com
BBB Accredited since 2006 · 20+ years training Houston professionals