Preloader spinner

Join our live online, instructor-led class on upcoming public dates, or book a private session for your team - online or onsite at your office. You will see demonstrations, practise with guided exercises and ask questions throughout the session. Delivered via Microsoft Teams. Certificate and quick reference guides included.

Image of laptop displaying an image containing the words Microsoft Power BI

Course Schedule

29
Sep 2025
An icon of a clock

1 day

An icon of a clock

9:30am - 4:30pm (UK Time)

An icon representing a location

Online Live

Price:
Discounted Price:

£300 per delegate

Overview

Duration

1 Day

Aims

This Microsoft Power BI Desktop Advanced training course is for anyone looking to create formulas using the advanced DAX functions. You will create calculations using calculated columns, measures, quick measures, and tables. You will use the Power Query Editor to clean up your data tables and generate structured reports.

 

Prerequisites

Delegates should have attended the Intermediate course or have previously used Power BI and can create visuals and basic calculations using calculated Columns & Measures.

To participate fully in this course, each delegate must have Microsoft Power BI Desktop installed on their computer prior to the course. As this is a practical, hands-on session, delegates will be expected to follow along and complete exercises throughout the day. Microsoft Power BI Desktop is available as a free download from the Microsoft website, but please ensure your computer meets the minimum system requirements to run the software smoothly before attending the course.

 

Objectives

On completion of this course, delegates will be able to:

  • Work in the Power Query Editor to transform data
  • Create calculations using Advanced DAX Functions
  • Add tooltips, conditional formatting and sparklines to visuals
  • Create Custom column calculations
  • Append and Merge Queries

 

Course Content

Data Sources

  • Copying and entering data into a table
  • Importing a Folder

Power BI Query Editor (PQE)

  • Column Quality / Profile and Distribution
  • Detect Data types
  • Split Columns
  • Use Custom Column to create calculation
  • Adding Conditional Column
  • Column From Example
  • Index Column
  • Transpose
  • Group By (Basic / Advanced)
  • Editing data in an existing table
  • Append and Merge queries

Advanced Visualisation Features

  • Applying Conditional formatting to dynamic titles
  • Using a Slicer to return different results
  • Adding Tool Tips Page
  • Adding Sparklines (column / lines) to visuals
  • Managing Visualisation relationships e.g. properties

Advanced DAX  Functions (Calculated columns, Measures, Quick Measures and New Table)

  • Relationship Functions (e.g. RELATED, RELATEDTABLE)
  • Aggregation and Iteration Functions (e.g. SUMX, AVERAGEX)
  • Text Functions (e.g. MID, FIND, FORMAT)
  • Logical Functions (e.g. IF, AND, SWITCH)
  • Date Functions (e.g. DATEDIFF, DATEADD)
  • Filter Functions (e.g. ALL, CALCULATE, FILTER)
  • Information Functions (e.g. CONTAINSSTRING, ISBLANK)
  • Table Manipulation Functions (e.g. SUMMARIZE, VALUES)
  • Time Intelligence Functions (e.g. DATESYTD, DATESMTD)
  • Math and Trig Functions (e.g. DIVIDE, ROUNDUP)

Hints and Tips

  • Calculations
  • Power BI Reports in PowerPoint
  • Edit Interactions with Slicers
  • Image URL

Download PDF Outline

Frequently Asked Questions (FAQs)

Who should attend the Power BI Desktop Advanced course?

Users confident with the basics and intermediate features who want to master complex DAX, advanced visuals, Power Query transformations and data modelling.

What are the prerequisites?

You should have completed an intermediate Power BI course or be able to create visuals and basic calculations using calculated columns and measures.

How is the course delivered?

Live online via Microsoft Teams with an expert instructor, demonstrations and guided practical exercises.

Do I need Power BI Desktop installed?

Yes. Please install Microsoft Power BI Desktop before the course so you can follow the hands-on exercises.

Does the price include VAT?

No. The price (£300) excludes VAT at 20%. VAT is added at checkout for UK customers where applicable.

How do I book a place?

Use the booking/enquiry options on this page, tell us your preferred date, and we’ll confirm availability and send joining instructions.

Public Schedule

RRP:  
£495 per delegate
Our price:  
£300 per delegate

Private Virtual Training (Teams / Zoom)

Contact us for pricing

Private Onsite Training (at your offices)

Contact us for pricing

Note

All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

ENQUIRE or book this course

You may also like...

Microsoft Planner Basic

Master the basics of Microsoft Planner in this half-day virtual course. Learn to create plans, assign tasks, and collaborate with your team.

An icon of a clock
Duration:

Half Day

Microsoft Excel Power Query

Learn to transform, clean, and analyse data with Power Query. Import, merge, and create insightful reports in Excel. Half-day course.

An icon of a clock
Duration:

Half day

Microsoft Excel Power User

This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.

An icon of a clock
Duration:

1 day

Enquire or book this course

Microsoft Power BI Desktop Advanced

If you would like to book a scheduled course, please let us know the number of delegates and your preferred date(s).

We will confirm availability and send you a booking form to complete.

Thank you!

Your enquiry has been received and we will come back to you shortly.

If you don’t hear from us within 2 working days, please check your junk or spam folder, just in case our response has ended up there.
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.