All courses available in-class or via remote login

How To Use Power BI DAX

What is DAX and how to use it in Power BI?

December 06, 2019

What is DAX and how to use it in Power BI?

We all know that Power BI is an incredibly powerful and interactive data visualisation tool.  Regular users of Power BI often like to take their skills and modelling abilities to the next level by learning how to write DAX on their own, which stands for Data Analysis Expressions.  DAX is the formula language used in Power BI and is also used in other Microsoft programs such as Power Pivot.  Read on for a quick lesson into what DAX is and how you can use within Power BI.

What is DAX?

DAX is a functional programming language, meaning the full executed code is contained inside a function.  It’s designed to work with tables, so the language has only two primary data types:  Numeric (includes integers, decimals and currency), and Other (includes strings and binary objects).  Because DAX uses operator overloading, it means users can mix data types in their calculations and their results will change automatically based on what type of data was used.

DAX calculations and functions

There are two primary calculations you can create using DAX, which are calculated columns and calculated measures.

Calculated columns are useful when you want to slice or filter on the value, or when you want a calculation for every row in your table.  On the other hand, calculated measures are useful when you want to calculate a percentage or ratio or you need complex aggregations.

There are many functions available within DAX to help you shape, form and analyse your data.  The functions within DAX are often grouped into categories such as aggregation functions, counting functions, logical functions, information functions, text functions and date functions.

Learning to write DAX functions and understand expressions is key for users who want to build on their data analysis skills.  With even a one-day course, users can learn to create complex expressions, manage and create DAX and learn methods to optimise their expressions.

To learn more about DAX and how to best use it for your business, you can check out our courses here.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25938 Reviews
Being custom arranged for what is used in this workplace was a large benefit and Steven use the Nexacu examples but made sure he referred to how it related to QR examples. -Excel Customised Brisbane
Phoebe - Excel Customised, .
Course was use full. Step by step analysis of formulas and executing them was very much usefull. -Excel Customised Brisbane
Karan - Excel Customised, .
Good course -Excel Customised Brisbane
Mark - Excel Customised, .
Well constructed 1 day course. I felt it was at a good pace, worth while in certain items and excellent presentation. Steven did not go too far without ensuring everyone was up to date! Time to get some practice! -Excel Customised Brisbane
Colin - Excel Customised, .
Good and efficient training. -Excel Customised Brisbane
Sabine - Excel Customised, .
Very well run course -Excel Customised Brisbane
Sam - Excel Customised, .
A very informative course. -Excel Customised Brisbane
Andrew - Excel Customised, .
Steven was great, thank you -Excel Customised Brisbane
Tahlia - Excel Customised, .
Very useful -Excel Customised Brisbane
Nadia - Excel Customised, .
Great Session,Steven was very knowledgeable, kept us on track, willing to answer questions and very engaging. Thank you Steven. -Excel Customised Brisbane
Caralee - Excel Customised, .
Well presented and informative -Office365 Advanced Adelaide
Annie - Office365 Advanced, .
The instructor (Michael) is very good in explanation and has a good example to make everything clear and easy to understand. -SharePoint Site Owner Sydney
Nawaporn - SharePoint Site Owner, .
This has been a thorough learning experience covering all aspects SharePoint. The training was delivered professionally and was easy to understand. -SharePoint Site Owner Sydney
David - SharePoint Site Owner, .
Course was well run. -Office365 Advanced Adelaide
Stacey - Office365 Advanced, .
Great! Very easy to follow and informative -Power BI Beginner Melbourne
Connie - Power BI Beginner, .
Progressed at a good pace but Ken was happy to go back over something if required. Came away with a good foundation to start working with data. -Power BI Beginner Melbourne
James - Power BI Beginner, .
Thank you -Power BI Beginner Melbourne
Phill - Power BI Beginner, .
A Good Start for Power BI -Power BI Beginner Melbourne
Peter - Power BI Beginner, .
very well presented. great pace, easy to understand and keep up -Power BI Beginner Melbourne
Wendy - Power BI Beginner, .
Great session for learning how to navigate p/bi at the foundation level. -Power BI Beginner Melbourne
catherine - Power BI Beginner, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us