Description

Build advanced DAX skills in Power BI: columns, measures, and tables, row and filter context, multi-table and time calculations, error handling, and testing in DAX Studio.

Price$900Per person

Time9 course hoursOn-demand video and labs, plus 1 hour of coaching

DeliveryOn-demand asynchronous trainingWith online support and 1 hour of coaching

CredentialCertificate of completionFrom We Can Code IT

About this course

This course is entirely about DAX, the formula language behind Power BI calculations. You will learn when to use a calculated column, a measure, or a calculated table, and you will see row and filter context at work rather than just reading definitions. You will then write multi-table, iterator, and time-based calculations, handle errors cleanly, and use DAX Studio to test and speed up your measures.

Who it is for

This course suits data analysts, BI developers, and report owners whose reports need calculations beyond simple sums, and anyone who maintains measures written by someone else.

Prerequisites

A working star-schema model in Power BI and a few simple measures

Completion of WCCI's Data Model Design Using Power BI course, or equivalent experience, is recommended

Requirements

Requires a Windows PC

Power BI Desktop (free, Windows only)

DAX Studio (free third-party tool, Windows only); your IT team may need to approve the install

What you will be able to do

You will be able to choose between a calculated column, a measure, and a calculated table for a given requirement and explain why.
You will be able to predict how row context and filter context change a measure's result in a visual.
You will be able to calculate across related tables using CALCULATE, RELATED, and RELATEDTABLE.
You will be able to write iterator and table expressions with SUMX, FILTER, and ALL, and handle errors with DIVIDE, IFERROR, and BLANK.
You will be able to build moving averages, period comparisons, and semi-additive balance measures.
You will be able to time a slow measure in DAX Studio and Performance Analyzer and rewrite it to run faster.

Syllabus

Columns, Measures, and Calculated Tables 1.5 hours

Calculated columns, Measures, Calculated tables, Variables and commenting.

Lab: You will solve the same business question three ways and decide which approach belongs in the model.

Row Context and Filter Context 1.5 hours

Row context, Filter context, How visuals apply filters.

Lab: You will predict the result of a set of measures in a matrix, then check and explain each difference.

CALCULATE and Calculating Across Tables 1.5 hours

CALCULATE, RELATED, RELATEDTABLE, Multi-table calculations.

Lab: You will build measures that pull values across related tables to answer a margin question.

Iterators, Table Functions, and Error Handling 1.5 hours

SUMX, FILTER, ALL, DIVIDE, IFERROR, and BLANK.

Lab: You will write iterator measures for weighted results and make them return clean values when data is missing.

Time-Based Calculations 1.5 hours

Moving averages, Period comparisons, Semi-additive balances.

Lab: You will build a moving average, a period-over-period comparison, and a closing-balance measure for an inventory model.

DAX Studio and Performance Analyzer 1.5 hours

Connecting DAX Studio to Power BI Desktop, Running and timing queries, Performance Analyzer, Rewriting a slow measure.

Lab: You will find a slow measure, time it in DAX Studio, and rewrite it to run faster.

Coaching sessions 1 hour

One-on-one or small-group coaching, scheduled with your coach.

How it is delivered

How you learn

On-demand asynchronous training with online support, plus 1 hour of coaching.

Live or in person

Live online or in-person sessions are available for an additional fee. Email admissions@wecancodeit.org for details.

TechCred

Eligible credential

DAX for Power BI

Reimbursement applies only to the credential approved in your TechCred application, so use the exact credential name shown on this page.

Funding

Ohio's TechCred program may reimburse eligible Ohio employers up to $1,000 per person, per credential, and up to $30,000 per application, for eligible costs such as tuition and certification costs.

This price is within TechCred's maximum of $1,000 per person, per credential.

Timeline

The current application period opens at 9:00 a.m. on October 1, 2026 and closes at 3:00 p.m. on October 30, 2026.

Training must start no earlier than the first day of the application period and be completed within 12 months of the award date.

What we provide

For each learner, We Can Code IT provides an itemized per-person invoice that shows the exact credential name, and a certificate that shows the learner's name, the credential and the date earned (or the vendor's exam record for certifications). We can also send a written quote to include with your TechCred application.

Pricing is the same for all customers, whether or not you use TechCred.

We Can Code IT is an independent training provider. Being listed as an eligible TechCred provider is not an endorsement by the State of Ohio and does not guarantee funding. The Ohio Department of Development makes all TechCred decisions, so check the state's current program guidelines before you apply. Program details: the State of Ohio’s TechCred page.

Enroll your team

One or a few learners

Choose the number of seats, add the course to your cart and check out.

A group, or a written quote

Send the form below for group enrollment or a written quote to include with your TechCred application. We reply within one business day. You can also email admissions@wecancodeit.org.

Request group enrollment or a written quote

Tell us about your team and we will reply within one business day.

← Back

Thank you for your response. ✨

Name

Work email

Organization

Number of employees

When would training start?

Delivery

Send us a written quote to include with our TechCred application

Anything else we should know?

We Can Code IT, LLC, 26300 Cedar Rd, Suite 1105, Beachwood, OH 44122. Registered with the Ohio State Board of Career Colleges and Schools, Registration No. 15-03-2064T.