DAX Studio - Excelerator BI

DAX Studio

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 …

When to Use SUM() vs SUMX() Read More

Extract Table Size from Power BI Desktop Using DAX Studio

I was explaining to one of my blog readers recently how to extract table size from Power BI Desktop using DAX Studio and thought it would be useful for others.  I have covered the basics …

Extract Table Size from Power BI Desktop Using DAX Studio Read More

Virtual Filters Using TREATAS

Level: Intermediate I have been aware of the TREATAS function for a very long time.  I have tried to understand how it works a few times but could never really work it out. I think …

Virtual Filters Using TREATAS 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

How to Document DAX Measures in Excel

Level: Beginners I often get asked if there is an easy way to create documentation for DAX measures when using Power Pivot for Excel.  I am not a big fan of documentation for the sake …

How to Document DAX Measures in Excel Read More

Excel Workbook Connection to Local Power BI Desktop

Today I am sharing an easy way to use Power BI Desktop as a SSAS tabular server on your local PC.  I find increasingly that I am building data models in Power BI Desktop and …

Excel Workbook Connection to Local Power BI Desktop Read More

LASTNONBLANK Explained

Level: Intermediate Last week at my Sydney training course, one of the students asked me a question about LASTNONBLANK.  This reminded me what a trickily deceptive function LASTNONBLANK is.  It sounds like an easy DAX …

LASTNONBLANK Explained 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

A Fabulous new Excel Add-In for Power Pivot

I’m really excited to share with you a new Excel Add-in that was authored by Bertrand d’Arbonneau and has recently been made available via SQLBI.com The Add-in called Power Pivot Utilities combines a number of …

A Fabulous new Excel Add-In for Power Pivot Read More

Extract Measures from an Excel Workbook

I was working with a client last week and the unthinkable happened.  The client made a simple editing mistake inside the Measure editing dialogue box and it corrupted the Power Pivot workbook. We could still …

Extract Measures from an Excel Workbook Read More

DAX Studio 2.0 released today

Great news for Power Pivot for Excel users – DAX Studio has had an update over night and version 2.0 is now available. For those of you that don’t know DAX studio, it is an …

DAX Studio 2.0 released today Read More

Scroll to Top