Course
|
Power BI

Introduction to DAX

Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create calculated columns and measures using DAX
Create new tables in the data model
Use aggregate functions like SUM and AVERAGE
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Power BI

Introduction to DAX

Power BI's formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
2 HOURS
Advanced
12 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Create calculated columns and measures using DAX
Create new tables in the data model
Use aggregate functions like SUM and AVERAGE
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

12 Lessons
Creating Calculated Columns
6 MINS
LESSON
Creating Calculated Columns
Exercise

Calculated columns let you add new columns to the tables in the data model. Learn how to create these new columns in this lesson.

Creating and Using Measures
5 MINS
LESSON
Creating and Using Measures
Exercise

Measures are calculations that can be added to the data model. In this lesson, we'll create some new measures and learn when to create a measure and when to create a column.

Creating Calculated Tables
3 MINS
LESSON
Creating Calculated Tables
Exercise

You can add a new table to the data model in Power BI using DAX formulas. In this lesson, we'll create a new table and create a relationship with the existing table.

Aggregation Functions
5 MINS
LESSON
Aggregation Functions
Exercise

Aggregate functions, such as SUM, AVERAGE, MIN, MAX and so on, calculate a simple formula over a column of data. We'll look at some of the most common aggregate functions in this lesson.

Using the Calculate Function
4 MINS
LESSON
Using the Calculate Function
Exercise

Calculate is almost certainly the most powerful function in DAX. It filters the dataset and evaluates another formula, in one function. We'll introduce Calculate in this lesson.

Introduction to Logical Functions
5 MINS
LESSON
Introduction to Logical Functions
Exercise

Logical functions, such as IF statements, allow you to test conditions. DAX's conditional functions work very similarly to those of Excel, as we will see in this lesson.

Complex Logical Functions
4 MINS
LESSON
Complex Logical Functions
Exercise

In this lesson, we continue looking at conditional functions, seeing how you can build more complex conditions using the AND and OR functions.

The Switch Function
3 MINS
LESSON
The Switch Function
Exercise

Testing many conditions using IF statements can quickly become difficult to read. The Switch function provides an alternative that is much easier to understand.

The RankX Function
4 MINS
LESSON
The RankX Function
Exercise

Ranking things is a very common business task. Learn how to do it in this lesson using the RankX function.

Count and Distinctcount
4 MINS
LESSON
Count and Distinctcount
Exercise

Two of the major count functions in DAX are Count and DistinctCount. In this lesson, we will see both and learn the difference between the two.

Extracting Text Strings
6 MINS
LESSON
Extracting Text Strings
Exercise

Working with text data is another common business task. In this lesson, we'll see several ways to find a particular string within a text field.

Combining and Splitting Text Fields
5 MINS
LESSON
Combining and Splitting Text Fields
Exercise

Continuing our look at text functions, we will see how to combine and split columns of text data.

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo