Build your ultimate AI agent
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!Feels like what you want to learn?
Start Course for FreeWhat 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.
Prerequisites
Curriculum
Course outline
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.
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.
3
Table Manipulation Functions
In this chapter, you'll learn table manipulation functions in DAX. Let's summarize!
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.
Intermediate DAX in Power BI
Course
Complete
