Name: BI Training
Address: AU
Telephone: @
Price range: @

Calculating Elapsed Business Hours Using DAX Part 2

By Matt Allington / June 30, 2020 July 9, 2020 / How to, Intermediate, Learning Resource, Power BI Desktop, SUMX

I have learnt a lot over my 50 something years in life, and one of my greatest learnings is that “it doesn’t matter how much you already know, there is still more to learn”. Hopefully this is one of the reasons you read my blog – because you want to […]

Power BI Webinar Overflow Q&A

By Matt Allington / October 10, 2019 January 3, 2020 / Beginners, Learning Resource, Power BI, SUMX

Last week I held a free Power BI webinar for people starting out with Power BI who are wondering why they should invest time in learning about DAX. I had more than 700 people register and was completely overwhelmed by the response. There were a few questions that I didn’t […]

Simple Filters and Syntax Sugar in DAX functions

By Matt Allington / April 9, 2019 December 24, 2021 / ALL, CALCULATE, DAX, FILTER, Intermediate, Learning Resource, SUMX

Level: Intermediate There is a concept in the DAX language called “Syntax Sugar”. Simply put, the developers have created simplified versions of more complex formulas to make it easier for people to learn and use the DAX functions. Here are a couple of examples. Total Sales Syntax Sugar = SUM(Sales[ExtendedAmount]) […]

When to Use SUM() vs SUMX() in DAX

By Matt Allington / October 30, 2018 October 10, 2022 / Beginners, DAX, DAX Studio, Intermediate, Learning Resource, Performance, SUMX

Level: Beginners/Intermediate (originally posted 2015, updated 2017, 2018, 2022). This article is one of the most frequently read on my blog site and I wanted to update it to continue to improve the value people get from my site. Even if you have read this article before, why not take […]

Uses for DAX as a Query Language

By Matt Allington / March 28, 2017 December 25, 2019 / DAX, DAX Queries, DAX Studio, How to, Intermediate, Learning Resource, Power BI Desktop, PowerPivot, SUMX

Level: Intermediate This is the final article in my series about DAX as a Query Language. In my first article I introduced DAX as a Query Language and then in my second article I went in deeper to the specifics on how to use some of the more useful DAX query […]

DAX as a Query Language Part 2

By Matt Allington / March 21, 2017 December 25, 2019 / DAX Queries, DAX Studio, How to, Intermediate, Learning Resource, PowerPivot, SUMX

Level: Intermediate In my last article I introduced DAX as a Query Language and explained why learning to query your data model can be useful. I covered the basics about using a tool like DAX Studio to query a database and return a table of data as a result. In this […]

Measures on Rows – Here is How I did it

By Matt Allington / July 19, 2016 February 19, 2020 / DAX, How to, Intermediate, Learning Resource, Power BI, Power BI Desktop, PowerPivot, SUMX

Level: Intermediate Update: 2019. You can now do this natively in a Matrix, but this is still a good trick that can be used to solve various problems. You may or may not be aware that it (previously was) not possible to put Measures on rows in a Matrix in […]

A Double CALCULATE Solves a SUMX Problem

By Matt Allington / May 31, 2016 December 19, 2019 / Intermediate, Learning Resource, SUMX

Level: Intermediate I helped a member at http://powerpivotforum.com.au with a problem last week that ended with an interesting solution. The explanation of how it worked was a bit complicated and worthy of sharing, hence this is the topic of today’s post. Count the Working Days Between Two Dates The requirement […]