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 24262 Reviews
Great session to understand how to use Power Query to set up Data Tables that are then useful in Power BI for Visuals. A good introduction to DAX, M expression writing. and row level security. Jason paces the session well and makes it easy to understand. -Power BI Intermediate Brisbane
Karen - Power BI Intermediate, .
Great Course with good info good interactions. -Power BI Intermediate Brisbane
Jason - Power BI Intermediate, .
It was a good pace and easy to follow. -Power BI Intermediate Brisbane
Hanh - Power BI Intermediate, .
Well Delivered course -Power BI Intermediate Brisbane
Mike - Power BI Intermediate, .
Great session - Jason is a passionate teacher who kept it interesting all day -Power BI Intermediate Brisbane
Shane - Power BI Intermediate, .
Learned a lot!!! Demonstration of examples was precise. This will definitely come in handy in my current role. Highly recommended workshop! Jason conveyed the lesson in a fantastic way -Power BI Intermediate Canberra
Sehla - Power BI Intermediate, .
Happy with how our questions were answered. -Power BI Intermediate Adelaide
Andrew - Power BI Intermediate, .
Jagg is ran a great session. It was a small group which meant that we could have covered more however I still learnt lots. -Power BI Intermediate Adelaide
Nikki - Power BI Intermediate, .
Need to make sure all desktop apps same version -Power BI Intermediate Adelaide
Gary - Power BI Intermediate, .
Course well delivered. Thank you -Power BI Intermediate Adelaide
Nayan - Power BI Intermediate, .
The course was useful. I learned some things that I will be able to directly implement in my work. -Power BI Intermediate Canberra
Leanne - Power BI Intermediate, .
Very informative -Power BI Intermediate Canberra
Carol - Power BI Intermediate, .
Course was informative but more basic than indicated on the website -Power BI Intermediate Canberra
Amee - Power BI Intermediate, .
Very comprehensive & interactive to ensure understanding of each concept -Power BI Intermediate Canberra
Elizabeth - Power BI Intermediate, .
I picked up some great tools and tips to apply in my current role. Danny was friendly, knowledgeable and helpful. The day was set out well and covered everyone's questions. -Excel Intermediate Sydney
Bree - Excel Intermediate, .
Danny was an excellent presenter . The course covered and touched upon helpful tips and short cuts . I'll highly recommend also to those who would like a refresher on VLookups and Pivot tables. -Excel Intermediate Sydney
Ashwini - Excel Intermediate, .
Great for learning more short cuts and brush up on your skills. Excellent Trainer Danny great. -Excel Intermediate Sydney
Antoinette - Excel Intermediate, .
Good Course, Good outline on features. Happy with pace and presenters clear communication. -Excel Intermediate Sydney
Brock - Excel Intermediate, .
Very good , lots of information to take in. Great course and instructor! -Excel Intermediate Sydney
Kirsten - Excel Intermediate, .
Danny was an excellent trainer and explained things thoroughly and patiently -Excel Intermediate Sydney
Antonia - Excel Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us