Level: Intermediate Updated: 10 Nov 2020 I first wrote this article about how to get tabular data from the Power BI Service into Excel back in Jan 2017. The benefits of extracting tabular data are still the same as they were back then however the process of extracting the tabular data […]
This article is a follow on from last week. I recommend you go back and read the article first if you missed it, but in summary, I want to write a measure (not a calculated column) that will return the median sales of products while excluding the products with blanks (no […]
Update 21 Feb 2018: There are 2 versions of this localhost workbook. One works with the downloadable version of Power BI Desktop and the other works with the Microsoft App Store version. There were some technical issues in late 2017, but as at Feb 2018 everything seems to be working […]
Level: Intermediate In this article I am going to write about the ALL() function, show how it works and explain a common use case. I will also cover the unexpected behaviour that occurs when using the ALL() function in Power BI Desktop – more on that later. For this article I […]
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 […]
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 […]
Level: Intermediate I have written quite a few articles that contain embedded references to DAX Queries and DAX Table functions in the past. Today I am writing an article that introduces the DAX query language from the beginning so you can learn how to use it and how it will […]
Level: Intermediate I had an interesting problem with a client last week where I built a data model to calculate rebates payable to customers based on their sales turnover. There were a few challenges that I am going to cover below, including: There needs to be a user friendly way […]
Level: Beginners DAX Studio is a fabulous free tool that allows you to directly query your Power Pivot/Power BI data models. It is not immediately obvious (particularly to beginners) exactly how using DAX Studio can add value. I often refer people on various forums to use DAX Studio but then […]
I was helping a participant at http://powerpivotforum.com.au with a problem. Long story short, she needed to return a table to Excel from a data model – not a Pivot Table. This concept can be a bit strange at first – let me explain. Tables – Not Pivot Tables A Pivot […]
Matt shares lots of free content on this website every week. Subscribe to the newsletter and you will receive an update whenever a new article is posted.
Excelerator BI | Expert Power BI Training | © 2020