Skip to main content
HomeBusiness Intelligence

Course

Intermediate DAX in Power BI

IntermediateSkill Level
4.8+
3,606 reviews
Updated 03/2026
Discover a wide range of DAX calculations and learn how to use them in Microsoft Power BI.
Start Course for Free
Power BIData Manipulation
3 hr
9 videos
25 Exercises
1,900 XP
50,821
Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Group

Training a Team?

Try for Business

Course Description

DAX for Logical Functions

This course introduces you to new DAX functions and its many use cases. First of all, you expand your core DAX knowledge by learning how to write logical functions.

Use DAX for Row-Level Security

Secondly, you’ll discover how you can write DAX functions for row-level security (RLS) purposes and how to use DAX to manipulate tables and create nested functions. Those time-intelligence quick measures will be building themselves before you know it!

Prerequisites

Introduction to DAX in Power BIData Modeling in Power BI
1

Logical Functions

In this chapter, you'll dive into logical functions! You’ll learn how to combine IF with other Power BI functions and discover the robust SWITCH function.
Start Chapter
2

Row-level Security

In the second chapter, you'll learn about row-level security, allowing you to change what data users see depending on their roles and permissions.
Start Chapter
3

Table Manipulation Functions

In this chapter, you'll learn table manipulation functions in DAX. Let's summarize!
Start Chapter
4

Time Intelligence Functions

In this last chapter, you'll expand your DAX knowledge with time intelligence functions. You'll even explore a way to create advanced visuals without writing DAX.
Start Chapter
Intermediate DAX in Power BI
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8
from 3,606 reviews
84%
15%
1%
0%
0%
  • Danni
    39 minutes ago

  • Dev
    3 hours ago

  • Darla Mae
    12 hours ago

  • Ana
    13 hours ago

  • Davie
    15 hours ago

  • Dilip
    18 hours ago

    Good Course..learnt something new..Thanks for that..

Danni

Dev

Ana

FAQs

Do I need to know DAX before taking this course?

Yes. This course builds on the DAX Functions in Power BI course and assumes you understand calculated columns, measures, and filter context. It is not a beginner DAX course.

What new DAX functions will I learn?

You will learn logical functions like IF and SWITCH, row-level security with DAX, table manipulation functions like SUMMARIZE and ADDCOLUMNS, and time intelligence functions like TOTALYTD and SAMEPERIODLASTYEAR.

What is row-level security, and how does this course cover it?

Row-level security restricts which data users can see based on their roles and permissions. Chapter 2 teaches you how to write DAX functions to create managed roles and implement security filtering.

Will I learn time intelligence functions in this course?

Yes. Chapter 4 covers time intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR, and teaches you how to build year-over-year quick measures.

Who will benefit from this course?

Power BI users who have completed the DAX Functions in Power BI course and want to write more advanced calculations, implement data security, and create time-based analyses.

    Join over 19 million learners and start Intermediate DAX in Power BI today!

    Create Your Free Account

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

    Grow your data skills with DataCamp for Mobile

    Make progress on the go with our mobile courses and daily 5-minute coding challenges.