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.
Data Model Design using Power BI Desktop – Level 2
- Proper understanding of DAX evaluation
- Controlling evaluation context
- Understanding relational functions
- Error handling within the data model
- Working with complex time intelligence calculations
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