Data Analysis Expressions, known as DAX, is the Function language that is used to solve data analysis problems in Power BI. DAX is used in the much the same way that you use Formulas to solve analysis problems in Excel. These expressions, when used in Measures, analyse our data by applying or removing specific filters from the data, filters that would be difficult to accomplish with the normal filtering tools in Power BI such as Slicers and Visual Level Filters.… Read More
DAX Blog Posts
By Burningsuit
Case Study DAX Learning Power BI Resources Training 24th July 2018
Case Study: Training Heathrow Airport Staff
Heathrow Airport is the UK’s largest airport, serving 204 destinations in 85 different countries and with 78 million passengers passing through the airport in 2017. Burningsuit have been providing Power BI Training and Consultancy to Heathrow Airport since August 2017. Heathrow Airport approached us after two of their staff members attended one of our Public Microsoft Power BI Service Courses in London in August 2017 and found the training useful and appropriate. Following this, Heathrow decided to book several on-site… Read More
By Burningsuit
DAX 9th July 2018
DAX: Is the Total Row in a table giving you grief?
If you are having issues with the total row of tables in DAX, this may be a familiar sight: When actually, all you want is this: So, what’s going on here? Why does my first table multiply the totals together, but my second table sum the values in the column above? Stuart Box, Owner of Burningsuit explains. Our solution to create the correct table In the first measure, “Sales V1”, I used this DAX expression: Sales V1 = SUM… Read More
By Burningsuit
DAX 15th June 2018DAX: How to group measures into numeric ranges
DAX (Data Analysis Expressions) is a useful library of functions used across Power BI, Excel and SQL. Stuart Box, Burningsuit's owner and trainer who is both a Microsoft Certified Professional and Member of the Learning and Performance Insitute, explains how to use DAX in Power BI to easily group or categorise numeric fields into ranges (sometimes called 'bins') below: How to group numeric fields Firstly, right click on the numeric field in the field list, as select “group”. Once grouped, you can… Read More
By Burningsuit
DAX Learning Power BI Resources 14th March 2018
DAX: How to use a slicer to select different measures
DAX (Data Analysis Expressions) is a library of functions used across Microsoft SQL, including Excel and Power BI. These operators can be combined to perform a range of actions, through building expressions and formulas. Here is how to use DAX in Power BI to create a slicer to select different measures in a chart, using our experience as training providers: Using a slicer to select different measures on a chart What if you want to use a slicer to select… Read More