ALL SLI DATES ARE GUARANTEED TO RUN!
Check out our full list of training locations and learning formats. Please note that the location you choose may be an Established HD-ILT location.
Overview
This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions.
Target Audience
Report Builders
Prerequisites
Data Model Design using Power BI Desktop – Level 2
Course Objectives
Full Course Outline
Lesson 1: Basic DAX Functionality
- Review of Calculated Columns
- Review of Measures
- Rules of Evaluation
- Evaluation Context
- Formatting DAX Code
Lesson 2: Controlling Content & Values
- Controlling Values – DAX
- M Language Custom Functions
- Error Handling
Lesson 3: Content Control Functions
- Iterative Functions
- FILTER Function
- ALL Function
- CALCULATE Function
Lesson 4: Contexts In Relationships
- Working With Many Tables
- Row Context & Relationships
- Elevated Calculated Columns
- Filter Context & Relationships
- Cross Filtering Issues
Lesson 5: Time Intelligence Functions
- Calculating Operating Periods
- To-Date Functions
- Controlling Totals
- Advanced Date Functions
- Prior Year Functions
Lesson 6: Appendix – Power BI Functions M Language
- Power BI Functions: M Language
- Basic M Language Queries
- M Language Syntax
- Adding Columns
- Duplication & Splitting Columns
- IF Expression
- Query Cleanup
- M Language vs. DAX Functions
Lesson 7: Appendix – Advanced Concepts
- Additional Uses Of The ALL Function
- Advanced-Data Tables
- Working with Missing Periods
- Working with Non-standard Years
- Parameter Tables
- Banding