DAX Queries - Excelerator BI

DAX Queries

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 …

Measure Dependencies in Power BI Read More

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 …

The ALL() Function in DAX 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 …

Uses for DAX as a Query Language 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 …

DAX as a Query Language Part 2 Read More

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 …

An Introduction to DAX as a Query Language Read More

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 …

Quadruple Nested SUMX or CROSSJOIN Read More

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 …

Getting Started with DAX Studio Read More

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 …

DAX Query Tables in Excel 2010 Read More

Scroll to Top