When to Use SUM() vs SUMX()-Level: Beginners/Intermediate (Updated Oct 2018). It has been 3 years since I first wrote an article about SUM() vs SUMX() and a year since I wrote this newer article. Over the years I have been teaching DAX, I have learnt new and improved ways to explain some of these complex topics. This article is one […]Read More
Uses for DAX as a Query Language-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 functions. In this final article […]Read More
DAX as a Query Language Part 2-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 article I am going to […]Read More
Measures on Rows – Here is How I did it-Level: Intermediate You may or may not be aware that it is not possible to put Measures on rows in a Matrix in Power BI. But I came up with a trick that makes it possible, so read on to find out how. Measures Can Only be Placed on Columns First the problem. The only […]Read More
A Double CALCULATE Solves a SUMX Problem-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 was to count the working […]Read More
Bring your data to life - Let's discuss how Matt can help!