Course
|
Excel

Advanced DAX Functions and Concepts

In our second course on Data Analysis Expressions, we'll look at areas of DAX that can be a little bit more difficult to implement, like time intelligence. We'll also demonstrate some of the important concepts that underpin DAX, such as contexts and filtering. Once you can understand this course, you'll be well placed to understand DAX comprehensively.
3 HOURS
Advanced
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Use DAX's date functions
Add a date table to a data model
Create variables in a data model
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
|
Excel

Advanced DAX Functions and Concepts

In our second course on Data Analysis Expressions, we'll look at areas of DAX that can be a little bit more difficult to implement, like time intelligence. We'll also demonstrate some of the important concepts that underpin DAX, such as contexts and filtering. Once you can understand this course, you'll be well placed to understand DAX comprehensively.
3 HOURS
Advanced
11 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Use DAX's date functions
Add a date table to a data model
Create variables in a data model
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

11 Lessons
Using Date Functions
6 MINS
LESSON
Using Date Functions
Exercise

DAX provides various functions that allow you to work with the date fields in your data model. We'll see how to identify first and last dates in your data and extract various pieces from a date field.

Adding and Using Date Tables
5 MINS
LESSON
Adding and Using Date Tables
Exercise

When you want to use time intelligence functions in DAX, you'll need a date table. We'll see why date tables are needed, what they generally contain, and how to add them to the data model.

Time Intelligence Analysis
5 MINS
LESSON
Time Intelligence Analysis
Exercise

In this lesson, we'll look at common time intelligence functions. We'll see how to add time to a date field, find the difference between two dates, and how to group dates on a monthly or quarterly basis.

Working with Variables
6 MINS
LESSON
Working with Variables
Exercise

Introduced in 2015, variables allow you to make long DAX formulas much easier to write and read. We'll see how to create variables in this lesson.

Using Relational Functions
5 MINS
LESSON
Using Relational Functions
Exercise

DAX has two relational functions, allowing you to use data from one table in a calculation in another table. We'll see both functions in this lesson.

Applying the Filter Function
4 MINS
LESSON
Applying the Filter Function
Exercise

Filtering is a very important concept in DAX. In this lesson, we will look at the Filter function, and use it in a Calculate function on a subset of our data

Other Filtering Functions
6 MINS
LESSON
Other Filtering Functions
Exercise

In this lesson, we will look at the remaining filtering functions in DAX, including the important All function as well as functions such as Values and Distinct

Understanding the Row Context
5 MINS
LESSON
Understanding the Row Context
Exercise

In DAX, we don't refer to individual rows in our formulas, unlike Excel. In this lesson, we'll see how the row context tells DAX which rows

Multiple Row Contexts
5 MINS
LESSON
Multiple Row Contexts
Exercise

Sometimes a DAX formula can have more than one row context. We'll see what problems this can cause and how you can solve those problems in this lesson

Understanding Filter Contexts
4 MINS
LESSON
Understanding Filter Contexts
Exercise

The filter context seems simple, but is possibly the most advanced concept in DAX. We'll see how it works and what you need to be careful of when dealing with filter contexts.

Context Transition in Power Pivot
4 MINS
LESSON
Context Transition in Power Pivot
Exercise

The Calculate function is capable of changing a row context into a filter context. We'll see the effect of this transition, and find out when it occurs in this lesson.

LESSON
Exercise

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