Microsoft Power BI (Dax Formulas)

Overview

This one-day advanced course builds on the foundational skills covered in Power BI (Level 1). Participants will deepen their understanding of DAX formulas, data modelling and advanced reporting techniques. The course introduces calculated columns and measures, advanced time intelligence functions and the creation of dynamic, automated reports. Learners will also gain experience designing measures tables and optimising their data models for enhanced performance and analysis.

By the end of the course, delegates will be able to create robust, professional Power BI reports that support HR, Payroll, Training and other business functions with accurate, interactive data insights.

Course Details

Objectives

Participants will learn to:

Generate and manage Date Tables using DAX, CALENDAR and CALENDARAUTO.
Apply advanced DAX date and time functions such as DAY, MONTH, YEAR, WEEKDAY, WEEKNUM and QUARTER.
Use calculated columns and measures to enhance data models.
Implement logical and conditional formulas using IF, AND, OR, SWITCH and nested functions.
Employ X-functions (SUMX, AVERAGEX, COUNTX, MINX, MAXX) for iterative calculations.
Apply filter and ranking functions such as ALL, REMOVEFILTERS, ISBLANK and RANKX.
Create time-based measures like Year-to-Date, Prior-Year and Opening Balance calculations.
Build and maintain a Measures Table to streamline reporting.
Optimise calculations and prepare data models for efficient, interactive reporting.

Delivery Methods

Facilitated by a competent and experienced subject-matter trainer using interactive, experiential techniques such as questions, demonstrations, discussions and hands-on exercises.

Who should attend?

This course is designed for users who already have basic knowledge of Power BI and want to perform advanced data modelling and analytical reporting. It is especially beneficial for:

Data Analysts and Business Intelligence Professionals
HR and Payroll Analysts
Training and L&D Managers
Finance, Accounting and Operations Managers
Project Managers and Business Advisors

Includes

Comprehensive Manual
Lunch and Refreshments (not applicable to on-site / online training)
Electronic Certificate (on successful completion of the course)
Electronic Delegate Feedback Questionnaire

Ready to Build a More Skilled Team?

Give your staff the practical training they need to work with more confidence, capability, and professionalism. Explore PST Training’s courses, workshops, and seminars today.