INSTRUCTOR-LED COURSE
Introduction to DAX for Power BI Desktop Users – Level 3
Course Information
Duration: 2 days
Version: Power BI L3
Price: $1,190.00
Certification:
Exam:
Learning Credits:
ALL DATES GUARANTEED
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 with a virtual live instructor.
COURSE DELIVERY OPTIONS
- Live Classroom
Train face-to-face with the live instructor.
- Established HD-ILT Location
Interact with a live, remote instructor from a specialized, HD-equipped classroom near you.
- Virtual Remote
Attend the live class from the comfort of your home or office.
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.
Prerequisites:
Data Model Design using Power BI Desktop – Level 2
Target Audience:
Report Builders
Course Objectives:
- Proper understanding of DAX evaluation
- Controlling evaluation context
- Understanding relational functions
- Error handling within the data model
- Working with complex time intelligence calculations
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