All courses available in-class or via remote login

power bi courses nexacu

Power BI Introduction to DAX

What is DAX?

DAX is the formula or expression language used in Power BI. Looking much like Excel formulas, DAX can be used to create tables, add columns to existing tables and to define “measures”. Meaures are calculations used in reporting of data and metrics. To take modelling in Power BI up a notch, you will need to understand DAX.

We will begin by revisiting the basic concepts of Excel formulas and then focus on where DAX is used in Power BI. We will introduce Quick Measures, the easiest way to perform calculations without writing any code. Then we will demonstrate some basic DAX functions before wrapping up with some suggested next steps based on your learning needs.

Book Now
Course Details
Price
$99
Duration
60 minutes
Instructor Led
yes
CPD Hours
1 hour
Access
12 month
Skill Level
Intermediate
Course Prerequisites

There are basic skills and software requirements for this workshop. To get the most out of this webinar, make sure you have the software ready to go.

Skill Requirements:

  • Able to use common Excel forumulas (such as IF, SUM, VLOOKUP)
  • Able to create Power BI reports, dashboards and visuals
  • Familiarity with Power BI Desktop and basic data models
  • Understand Get Data and how to create relationships between tables

Software Requirements:

  • Microsoft Excel and Power BI Desktop

Learning Outcomes

  • What and Where is DAX
  • What is the DAX language
  • Where is DAX used

 

  • Formulas in Excel
  • Structure of Excel Formulas
  • How Excel formulas translate to DAX

 

  • Power BI Data Modelling
  • Getting started with Data Modelling
  • Tables and Relationships

 

  • Aggregations in Power BI visuals
  • Using DAX to Aggregate

 

  • Quick Measures in Power BI
  • What are Quick Meaures
  • Creating a Quick Measure

 

  • Basic DAX functions in Power BI
  • What is a DAX Function
  • Creating a basic DAX function

 

  • Creating tables, measures and columns
  • Create a Table
  • Create a calculated column
  • Create a measure

 

  • Learning stages of DAX and useful resources
  • What to expect on the DAX journey
  • Where to from here
Instructor Led Courses
microsoft_gold
Try our skills test

Test your skills and find out which course is right for you.

skills test nexacu

Choose a Quiz

 

Contact Us


How do Online Courses work?

online training support

Book

Find the online course or webinar you

would like to sit and hit book now.

small class size

Login

Receive your login details and follow the instructions

to log on to the Nexacu learning portal.

microsoft certified



Learn

Complete your online course or view

your webinar at your own pace.

System Requirements

Browser

  • Internet Explorer: Version 9 to 11
  • Firefox or Google Chrome: Latest Version

Software requirements

  • Microsoft Windows 7/8/10
  • Apple Mac OS X 10.5.x, 10.6.x *(Online self-paced courses courseware works with Mac OS, diagnostic tests do not.)

Contact Us

Nexacu Phone Icon phone
Nexacu Envelope Icon Task email
Nexacu Form Icon enquiry

What is Remote Training?

Valued by Individuals

4.8/5
Over 25102 Reviews
Thanks -Power BI Intermediate Canberra
Mal - Power BI Intermediate, .
Jason did an amazing job, very attentive, personable, and approachable. Always willing to slow down and make sure everyone is on the same page and answer questions. -Power BI Intermediate Canberra
Logan - Power BI Intermediate, .
John was great. Great handbook for reference. Could potentially look at adding more to the course. Calendar's aren't really needed with everything else available. But I would be curious to see what else Visio can do. Thanks again! -Visio Essentials Melbourne
Amber - Visio Essentials, .
John was great and patient! -Visio Essentials Melbourne
Rebecca - Visio Essentials, .
Excellent trainer, concise, explained material very well and was very patient. -Excel Customised Adelaide
Mirella - Excel Customised, .
Totally enjoyed it -Excel Customised Adelaide
Bronwyn - Excel Customised, .
very knowledgeable -Excel Customised Adelaide
Beth - Excel Customised, .
Useful! Wowed me. -Excel Customised Adelaide
Ann - Excel Customised, .
Great session with some insightful tips and tricks! -Power Point Level 1 & 2 Remote Online
Kellie - Power Point Level 1 & 2, .
Danny is an excellent instructor - very informative session with lots of helpful tips! -Power Point Level 1 & 2 Remote Online
Stephie - Power Point Level 1 & 2, .
I have attended from Beginner to Advance course in consecutive days. Having done almost 2 yrs of self learning, these courses has solidified my learning and has given me tips on how to do other things. Dom was great in all 3 courses. -Power BI Advanced Perth
Dion - Power BI Advanced, .
Dom is a great teacher. So knowledgable. -Power BI Advanced Perth
Kristal - Power BI Advanced, .
Excellent course for gaining a greater understanding of Power BI Advanced workings. Trainer is very thorough. -Power BI Advanced Perth
Siobhán - Power BI Advanced, .
Was a great session downloading the office 365 capabilities! -Office365 Intermediate Brisbane
Selvin - Office365 Intermediate, .
Great course with some really helpful and insightful tips and tricks which I can use in the work place and beyond. Steven was an amazing trainer who explained each of the processes clearly and easily to understand. Thank you so much! -Office365 Intermediate Remote Online
Kaimani - Office365 Intermediate, .
Great Course. Steven was a great instructor, was very clear in his instruction and kind whenever he had to re-address any content. He was also good at trying to cover the topics we were wanting to focus on. -Office365 Intermediate Brisbane
Emma - Office365 Intermediate, .
This was a great opportunity to fill in so many gaps I had in my day to day use of Power BI. Very user friendly and easy to follow. -Power BI Advanced Brisbane
John - Power BI Advanced, .
Jason was great and the course was extremely informative. -Power BI Beginner Canberra
Mark - Power BI Beginner, .
Examples were useful, good spread of key functionality and handy tips -Power BI Beginner Canberra
Ben - Power BI Beginner, .
It is a great course and Jason has done it very interestingly throughout the day. Thank you. -Power BI Beginner Canberra
Hemamali - Power BI Beginner, .
View More Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us