Measure Dependencies in Power BI
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 …
DAX Queries
The ALL() Function in DAX
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 …
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 …
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 …
An Introduction to DAX as a Query Language
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 …
Extract Tabular Data From Power BI Service to Excel
Level: Intermediate Someone asked me a question yesterday about exporting data from the Power BI Service into Excel. There are a few options to do this however they all have their problems (these problems are not …
Extract Tabular Data From Power BI Service to Excel Read More
Quadruple Nested SUMX or CROSSJOIN
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 …
Getting Started with DAX Studio
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 …
DAX Query Tables in Excel 2010
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 …