Power BI DAX Intermediate

Description

This intensive one-day Power BI DAX Intermediate course empowers experienced Power BI users to elevate their DAX skills for dynamic, user-responsive reports. Dive deep into advanced DAX techniques to create interactive elements like dynamic titles and conditional formatting, leverage time intelligence functions for powerful date-based analysis, and master ranking and semi-additive measures to deliver impactful insights. Perfect for those ready to transform their Power BI reports with advanced functionality and enhanced user engagement.

Course Outline

Dynamic Titles

Introduction to Dynamic Titles
The SELECTEDVALUE function
Nesting SELECTEDVALUE
Displaying Dynamic Text in Power BI
Using a Measure as a Visual Title
Concatenating Text Messages
Displaying Dynamic Text

Dynamic Formatting

Overview of the “fx” Button in Power BI
Displaying RAG Colours
Conditional Formatting Rules
Creating a Measure for Conditional Formatting
Applying a Measure as a Field Value

Interacting with the User

The DAX USERNAME Function
USERNAME and Row-Level Security

Ranking with DAX

The RANKX Function
Ranking Within a Group
The DAX TOPN Function

DAX Time Intelligence

Calendar Tables
Power BI Auto Date/Time Feature
Automatic vs Manual Time Intelligence
The TOTALYTD, TOTALQTD and TOTALMTD functions
Example
Specifying End of Fiscal Year
The SAMEPERIODLASTYEAR Function
Using the DATEADD Function for Maximum Flexibility
The PARALLELPERIOD Function
Calculating Running Totals
Calculating Moving Annual Totals

Semi-Additive Measures

Scenario Overview
Understanding the Semi-Additive Measure Concept
Creating the Semi-Additive Measure