Consulting Training Blog Careers About Us Contact Us

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

Upcoming Classes

Sorry, nothing scheduled right now. Click the Get Notified button below to be alerted when a class is 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 Recorded Webinar - Agile Design Principles, a Precursor to .Net Design Patterns

X