All courses available in-class or via remote login

Computer screen with graph

Importance of DAX in Power BI

March 29, 2018

If you are not a consistent user of Microsoft Power BI you are likely unfamiliar with the term “DAX”, however that doesn’t mean that you haven’t been using it! Data Analysis Expressions or DAX is the library providing users with an array of methods to analyse and shape data, and is a core component of SQL Server Analysis Services, Power Pivot in Excel and Power BI Desktop. A good understanding of DAX can make report authoring more simple and more powerful. However, without a functional language background it can often be overwhelming for beginners and even some seasoned veterans to understand the importance of DAX in Power BI.

 

So what is DAX?

First of all, DAX is mostly used to populate a new column in a table based on numbers, texts and related data. Also, like Excel (filing formulas up/down/right/left or table formulas) you write a DAX expression once for the column and it is evaluated for each row. Each time the data is refreshed the calculation is performed. Also DAX is commonly used in measures, a value (often numeric) that is used in a visual or table of your report.

The value is calculated every time the visual is refresh and the expression applies to that cell or element of the visual. So, one measure may be calculated many times within the one visual, under different contexts. Therefore, a valuable capability of DAX is the ability to modify that context to view data in a different way. A simple example of a measure is to calculate an average or total, and can be given a specific context such as a product colour, month of the year or any other attribute in the data model.

 

What’s so important about DAX?

Because it’s so simple to create a new Power BI Desktop file and import some data into it. It is also relatively simple to create reports without using any DAX formulas at all. But, the difficulty comes when you need to analyze data and related data elements in the model (such as growth percentage across product categories rankings and statistical outcomes over different date ranges). The more capable Business Intelligence creator, it is inevitable that you’ll need to learn and use DAX regularly. DAX formulas provide this capability and many other important capabilities as well. Learning how to create effective DAX formulas will help you extract the most useful information from your data. When you get the information you need, you can begin to solve real business problems that affect everything from your bottom line to the happiness of your clients.

 

Important things to know about DAX

1.Don’t worry about learning all functions in the beginning



DAX has many possible functions, and it can be hard to know where to start. Focus on the basic functions first:

SUM, AVERAGE, MIN, MAX

COUNT, COUNTROWS

CALCULATE

FILTER

IF


2.Learn the concepts

 

Instead of spending your time rote learning functions spend your time learning the core concepts and patterns of the language. This is the fastest and best way to learning DAX. Build a library of important DAX information and work in iterations. DAX may look like Excel functions but the underlying theory is very, very different. These fundamentals of the language must be understand early in the learning process.

 

 
3.Keep your functions as readable as possible



The nature of DAX functions means having a lot of calculations happening on a single line. Therefore, keeping your code legible is a priority. Delete unnecessary elements, use descriptive names, and be explicit with your references.

 

Object Names, Columns and Measures

  • If you don’t need it, delete it
  • Keep internal column names hidden
  • Rename columns, use calculated columns & measures to define user-friendly names
  • Use explicit measures were possible

 



4.Sort your measures by category



Have a mental template for the different types of calculated measures that you’ll encounter during the code process. Instead of starting over from scratch each time, you’ll already be halfway there with a rough outline for your function.

 

Define Measures in Categories:

  • Simple aggregates
  • Time variances
  • Ratios & differentials
  • Business – specific calculations

 

Learning DAX in Power BI can be confusing and challenging for new users and veterans alike. Hopefully after reading this article the language of DAX is a little less frightening.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 24317 Reviews
It was very educational. Steven explained all very clear. I definitely will use it in my work. cheers -Excel Advanced Brisbane
Olga - Excel Advanced, .
Found a number of things that I will be able to take back to the office and use. Steven presented and kept things flowing well. -Excel Advanced Brisbane
Amanda - Excel Advanced, .
The session was delivered in efficient way. Gained so many knowledge, new way of creating report based on data available. -Excel Advanced Brisbane
Ratih - Excel Advanced, .
Steven is a great tutor -Excel Advanced Brisbane
Donna - Excel Advanced, .
Great session. Very helpful. -Excel Advanced Brisbane
Jacinta - Excel Advanced, .
Steven was very patient, very knowledgeable and I learnt a lot while having a great time. Thanks heaps :) -Excel Advanced Brisbane
Chris - Excel Advanced, .
great course thank you -Excel Advanced Brisbane
Jodi - Excel Advanced, .
Good Course -Power BI Advanced Brisbane
Sunmeen - Power BI Advanced, .
Well done, knowledgeable presenter -Excel Advanced Brisbane
Chester - Excel Advanced, .
Great pace and content, trainer explained everything very well. -Power BI Advanced Brisbane
Ana - Power BI Advanced, .
Another very informative day with a full morning on DAX, a good look at dynamic row level security and other useful tools. A lot of information, but very helpful! -Power BI Advanced Brisbane
Karen - Power BI Advanced, .
It went a bit fast for topics that were new to me. For topics that I had a good understanding the pace was fine. -Power BI Advanced Brisbane
Robin - Power BI Advanced, .
Very informative, learnt a lot in one day! -Power BI Advanced Brisbane
Ashlee - Power BI Advanced, .
very good session -Power BI Advanced Brisbane
Lucy - Power BI Advanced, .
great session, very informative Jason is a great teacher! -Power BI Advanced Brisbane
Peter - Power BI Advanced, .
valuable session and definitely learnt some new things around our reporting presentations moving forward but also around our animations. Loved how interactive it was and that it is hands on being able to do the live training. -PowerPoint Level 2 Brisbane
Charmaine - PowerPoint Level 2, .
Stuart was a fantastic presenter. He really engaged everyone. I learnt a lot of great tips and tricks and can see them being used on a regular basis. Certainly some "ah ha!" moments too. Run really well and highly recommend Stuart as a presenter. -PowerPoint Level 2 Brisbane
Katrina - PowerPoint Level 2, .
Good presentation. Kept the day interesting and lots of learnings even though this is not my first powerpoint training session. Learnt some great useful skills I'm looking forward to trying out soon! -PowerPoint Level 2 Brisbane
Celia - PowerPoint Level 2, .
Stuart was very personable and an engaging presenter. -PowerPoint Level 2 Brisbane
John - PowerPoint Level 2, .
thank you Stuart, enjoyed the course very much, had a lot of take away. -PowerPoint Level 2 Brisbane
Susanna - PowerPoint Level 2, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us