An Introduction to DAX functions in Power BI

Location:

Format

Event

Type

Conference

Duration

1 hour

Join this webinar to hear from Simon Jeffery, Head of Financial Modelling at Throgmorton UK Ltd. Simon, a financial modelling and data analytics expert, will show you how to advance your Power BI reporting skills further, utilising the power of Power BI’s DAX programming language.

Learning outcomes

Increase the complexity and sophistication of your Power BI reports with DAX
Learning the basics of DAX programming
Why you need to learn DAX programming for Power BI

There are no upcoming dates for this Event

Product information

Overview

Professional development

All learning resources available in the CGMA Store qualify for CPD for CIMA members.

Duration:	1 hour
Format:	Event
Access:	This is a live event. You will receive information about the location, materials, and attendance after purchasing.

Return and refund policy

Programme outline

Simon will explain why Power BI report developers need to learn how to use DAX functions within Power BI in order to build more complex and sophisticated reports.

Simon will explain the basic principles of DAX and will then demonstrate how you can use DAX formulae to enhance your reporting – with practical examples.

The areas of DAX programming to be covered will include:-

Building a standard date table
Using basic functions like SUM and DIVIDE
Using CALCULATE – one of the most important DAX functions
Creating dynamic titles and buttons
Dynamic formatting using SWITCH
Using Time Intelligence functions

Who will benefits from attending this webinar?

Management Accountants who have a basic understanding of creating Power BI reports and who want to extend their knowledge of Power BI further and learn about the power of DAX programming.

Speaker Simon Jeffery Associate Director, Financial Modelling, Throgmorton UK Ltd

Simon is CIMA-qualified and has worked for over 30 years in commerce, specializing in data management, Excel modelling and business intelligence. He has created unique solutions for departments across the whole organisation including finance, marketing and operations. He currently works for Throgmorton UK Ltd, heading up the Financial Modelling team.