When to Use SUM() vs SUMX()-Level: Beginners/Intermediate (Updated Oct 2018). This is a further (third) update/edit to an article I first wrote 3 years back and then updated a year back. When I update my articles I simply change the original post with the latest data – that way only the current/latest version is available preventing people stumbling on old […]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
Begin your Power BI learning now - How can Matt help?