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. 

Logical functions

Interpreting SWITCH()

Logical functions in Power BI

IF() for formatting tables

Exploring SWITCH()

Grouping

Logical Functions

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.

Row-level security

Applying row-level security

Managed roles in Power BI

Creating an email list

Implementing RLS

Security filtering

Row-level Security

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

Table manipulation functions

Summary of SUMMARIZE()

Table manipulations using DAX

SUMMARIZE() the facts

ADDCOLUMNS()? No problem!

Table Manipulation 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.

Time intelligence functions

Time intelligence functions output

Time intelligence in Power BI

Use of TOTALYTD()

Use of SAMEPERIODLASTYEAR()

Build your own YoY quick measure

DAX vs Q&A

Congratulations!

Time Intelligence Functions

DAX Cheatsheet

DataCamp vs. Local Experience

Exercises and Datasets

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. 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!

<h2>DAX for Logical Functions</h2>
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. 
<br><br>
<h2>Use DAX for Row-Level Security</h2>
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!


Introduction to DAX in Power BI

Data Modeling in Power BI

Discover a wide range of DAX calculations and learn how to use them in Microsoft Power BI.

Intermediate DAX in Power BI

Data Analyst in Power BI

Grouping

Intermediate DAX in Power BI

Praktische interactieve oefening