Description
Overview:
This course takes an in-depth approach to the DAX language, teaching designers how to extend the capabilities of data models for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time-intelligence calculations.
Prerequisite(s):
Data Model Design using Power BI Desktop – Level 2
Audience:
Outline:
Lesson 1: Basic DAX Functionality
- Review of Calculated Columns
- Review of Measures
- Rules of Evaluation
- Evaluation Context
- Quick Measures
Lesson 2: Controlling Content & Values
- Controlling Values
- Error Handling
Lesson 3: Content Control Functions
- Iterative Functions
- The FILTER Function
- The ALL Function
- The CALCULATE Function
- Additional All Functions
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
Reviews
There are no reviews yet.