Excel
Excel PowerPivot Level 2: DAX Measures & Calculations
CPE Eligible - visit /cpe for details.CPE page →
Scheduled dates
No public dates scheduled yet
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course outline
Build DAX Calculations for PowerPivot
- Create Calculated Columns and Measures
- Understand DAX Formulas and Syntax
- Summarize Data using SUMX, MINX, MAXX, and AVERAGEX Functions
Improve 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
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
Advanced DAX Functions
- Handle Errors in DAX
- Understand How Drop Zones Affect Measures
- Respect and Ignore the Filters
Use Variables in DAX
- Learn Variable Syntax in DAX
- Employ Variables in Measures
Summarize Data using Time Intelligence
- Create a Rolling Average
- Create a Rolling Twelve Month Total