Course
Intermediate DAX in Power BI
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
Training a Team?
Try for BusinessCourse 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!What you'll learn
- Identify the appropriate DAX logical function — IF, AND, OR, NOT, or SWITCH — for a given conditional calculation scenario.
- Recognize how row-level security restricts data access in Power BI and evaluate the use of USERPRINCIPALNAME() for implementing dynamic role-based filtering.
- Differentiate between ADDCOLUMNS, SELECTCOLUMNS, and SUMMARIZE when constructing or transforming tables using DAX.
- Identify DAX time intelligence functions including SAMEPERIODLASTYEAR, DATESBETWEEN, and TOTALYTD, and assess their role in period-over-period analysis.
- Evaluate best practices for combining SUMMARIZE with ADDCOLUMNS to prevent unexpected calculation results in aggregated tables.
Feels like what you want to learn?
Start Course for FreePrerequisites
Introduction to DAX in Power BIData Modeling in Power BILogical Functions
Row-level Security
Table Manipulation Functions
Time Intelligence Functions
Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
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.