Power BI DAX Intermediate

£445.00


CPD Accredited Logo   6 hours of CPD  


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.

Clear
SKU: GCOM-DAXPU-102 Category:

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.

By the end of this one-day Power BI DAX Intermediate course, participants will be able to:

  • Create dynamic titles in Power BI visuals by using DAX functions like SELECTEDVALUE and CONCATENATEX for customized user interactivity.
  • Apply dynamic formatting techniques, including conditional formatting rules and RAG (Red-Amber-Green) colors, to enhance data visualization.
  • Leverage the USERNAME function to personalize content and set up row-level security for more secure, user-specific reports.
  • Use ranking functions such as RANKX and TOPN to perform advanced ranking, including ranking within specific groups.
  • Utilize DAX Time Intelligence functions for date-based analysis, such as TOTALYTD, TOTALQTD, TOTALMTD, and SAMEPERIODLASTYEAR.
  • Implement semi-additive measures to manage complex aggregation needs, ensuring accurate representation in specific visualizations.
  • Participants will leave with a solid understanding of intermediate DAX techniques, confident in their ability to build interactive, user-responsive reports with advanced analysis capabilities.
    • 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

Additional information

Date

12 November 2024 (Tutor-led, Online), 11 February 2025 (Tutor-led, Online), 15 April 2025 (Tutor-led, Online), 10 June 2025 (Tutor-led, Online), 5 August 2025 (Tutor-led, Online), 7 October 2025 (Tutor-led, Online)