When to Use SUM() vs SUMX()-It has been 2 years since I first wrote an article about SUM() vs SUMX(). I decided to write a new article to refresh this topic and add in the things I have learnt over the last 2 years. SUM() vs SUMX() First let me start with an overview of both of these functions. SUM() […]Read More
Uses for DAX as a Query Language-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 today […]Read More
DAX as a Query Language Part 2-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 go […]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!