Consulting Training Blog Careers About Us Contact Us
All Classes Will Be Held Virtually – Live Online Intertech's Training Division has been successfully instructing professionals through virtual live online training since the advent of the smartboard. It is a proven form and offers the convenience of live questions, group interaction, and labs with an instructor looking over your shoulder. Because of this, we will continue all classes live but virtually, including Agile and Scrum instruction, so businesses and individual’s seeking professional development can keep moving forward during these unexpected times.

Power BI for the Cloud - Level 3 - Advanced Languages Training

Upcoming Classes

Click the Get Notified button for priority notification when a class is next scheduled.

Get Notified

On Site/Private

Can't find a class that fits right for you? Contact us to inquire about scheduling your own private class

Contact Us

Description

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. This course will also introduce students to the M-Language and how it can be used to make querying more effective. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers, and understand the importance of the M Language and its uses.

Bring This Course To You

For groups of 5 or more, let Intertech bring this course to your location. Customized versions tailored towards your objectives are also available.

Learn More

Prerequisites

Power BI for the Cloud - Level 2 - Data Model Designer

Course Outline

Lesson 1 : Power BI Functions – M Language

M Language vs DAX Functions 
Basic M Language Syntax 
Working with Columns 
IF Expression in M Language 
Query Cleanup

Lesson 2 : Basic DAX Functionality

Review of Calculated Columns 
Review of Measures 
Rules of Evaluation 
Evaluation Context 
Formatting DAX Code

Lesson 3 : Controlling Content & Values

Controlling Values - DAX 
M Custom Functions 
Error Handling

Lesson 4 : Context Control Functions

Iterative Functions 
FILTER Function 
ALL Function 
CALCULATE Function 
Additional Uses Of The ALL Function

Lesson 5 : Contexts In Relationships

Working With Many Tables 
Row Context & Relationships 
Elevated Calculated Columns 
Filter Context & Relationships 
Cross Filtering Issues

Lesson 6 : Advanced Concepts

Controlling Totals 
Parameter Tables 
Banding

Lesson 7 : Time Intelligence Calculations

Working With Date Tables 
Calculating Operating Periods 
Working With Missing Periods 
To-Date Functions 
Advanced Date Functions 
Prior Year Functions

Free Resources from Intertech

Free On-Demand Video Bundle: IoT, Agile/Scrum, and Leadership

Free Whitepaper: Design and Code Review Checklist

Free eBook: Mastering The Daily Agile Stand-Up

X