PowerPivot - Excelerator BI

PowerPivot

Large Customer Sales

The FILTER Function in DAX Part 2

Level: Intermediate In my last article, I introduced the basics of the DAX FILTER() function. Hopefully that introductory explanation to FILTER() helped you get your head around what FILTER() is doing under the hood. With …

The FILTER Function in DAX Part 2 Read More

A further (final?) update about Power Pivot

This is the longest running blog post series I have on my website.  Why does Power Pivot Crash so often and what can I do about it?  I have three previous articles that you can …

A further (final?) update about Power Pivot Read More

My Presentations at the MS Summit and Portland UG

I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit (MBAS). I love attending conferences like this and it was a privilege to present on a few topics …

My Presentations at the MS Summit and Portland UG Read More

Power Pivot Global Interest

Way back in 2014 I decided to check out what Google Trends had to say about Power Pivot and Power Query global Interest. In case you don’t know, Google Trends will show you the relative …

Power Pivot Global Interest Read More

Number of Days between 2 Transactions Using DAX

Level: Intermediate I got my haircut today (pretty spiffy one too, even if I do say so myself).  While I was chatting I asked my hair dresser “on average, how often should I get my …

Number of Days between 2 Transactions Using DAX Read More

I’m Presenting at SQL Saturday Melbourne and Sydney

I’m presenting again this year at SQL Saturday Melbourne (30th June 2018) and Sydney (7th July 2018).  My topic this year will be “DAX as a Query Language“. What is SQL Saturday? SQL Saturday is an annual 1 …

I’m Presenting at SQL Saturday Melbourne and Sydney Read More

My Supercharge Excel and Supercharge Power BI Books Available on Amazon

After what seems like a lifetime of waiting for the paperback book economy to tick its required boxes, both of my new books Supercharge Excel and Supercharge Power BI are now available to ship to …

My Supercharge Excel and Supercharge Power BI Books Available on Amazon Read More

Show Me All Invoices Containing this Product

Level: Advanced I was answering an interesting forum question last week, and as is often the case I thought it would make an interesting article to share with you all here.  I have modified the …

Show Me All Invoices Containing this Product Read More

Compound Growth using DAX

There are some things that are very easy to do in Excel that don’t seem to have an immediately obvious and simple solution in DAX.  One such problem is when you want to apply compound …

Compound Growth using DAX Read More

How To Solve a Complex DAX Problem

Level: Advanced I was helping someone on Power Pivot Forum last week with a tricky calculated column question.  As an aside, you may know that I always advise beginners to keep away from calculated columns. …

How To Solve a Complex DAX Problem 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

Quick Measures and Query by Example

2 fabulous new updates again in the April update of Power BI Desktop.  Here is my quick review so you can see how great these things are. Quick Measures Quick measures are designed to help …

Quick Measures and Query by Example 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

Power BI Skills – Thinking of Data in Tables

Level: Beginners One very important concept that Excel users often struggle with when starting on their Power BI and Power Pivot journey is that they need to learn to think about data in tables rather …

Power BI Skills – Thinking of Data in Tables Read More

Relationships in Power BI and Power Pivot

Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular.  The technology is …

Relationships in Power BI and Power Pivot Read More

Best Practices for Power Pivot, Power Query and Power BI

Level: Beginners There are many best practices for Power BI, Power Pivot and Power Query.  I know these things so intuitively now that it is very easy to forget how I incrementally learnt these things …

Best Practices for Power Pivot, Power Query and Power BI Read More

DAX Time Intelligence Explained

Level: Beginners I help a lot of people on forums who ask questions about time intelligence for DAX.  If you are just starting out then the chances are that you may not even be clear …

DAX Time Intelligence Explained Read More

Data Modelling with OneDrive Source Files

Level: Intermediate Last week I shared how it was possible to easily create an online survey using Excel for O365.  Once such a survey is created, the data can be imported into PowerBI.com and used to …

Data Modelling with OneDrive Source Files Read More

Easy Online Surveys with Power BI Reporting

Level: Beginners I think today’s article will be of interest to my readers even though it is a little astray from my normally pure Power BI, Power Pivot and Power Query content. I will show …

Easy Online Surveys with Power BI Reporting Read More

Scroll to Top