Excel - Excelerator BI

Excel

Pivoting Text Data Using Power Query

It is very common to need to transform data from one “shape” to another “shape” before it can be used inside Power BI for analysis (although many beginners don’t realise this).   One such example is …

Pivoting Text Data Using Power Query Read More

Measure Tables in Power BI

I often get asked about measure tables during my Power BI online training classes. This post will discuss the merits of measure tables versus storing your measures in the table where the data comes from. …

Measure Tables in Power BI 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

Importing XLSB into Power BI

I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file.  I suggested she save the file as …

Importing XLSB into Power BI Read More

Extracting Complex Data from Websites

One thing I did a long time ago was set up my own forum called PowerPivot Forum. This forum is open to anyone to join and to ask questions and/or help others. If I have any spare …

Extracting Complex Data from Websites Read More

Using Power Query for Extracting Non-Tabular Data from Web Pages

Matt Here:  I first met Ivan via Twitter when he was living in Russia, and then in person when he moved to Australia to live in Sydney with his family. Ivan is a talented Power …

Using Power Query for Extracting Non-Tabular Data from Web Pages Read More

New Power BI Reports from a Golden Dataset

This is a further (third) update/edit to an article I first wrote on 18th April 2017 and then updated on 30th Jan 2018.  When I update my articles I simply change the original post with …

New Power BI Reports from a Golden Dataset 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

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

Open the Queries and Connections Pane Wider

Power Query for Excel has developed at a striking pace over the last few years making it hard to keep up with the changes.  Over several iterations, the Queries and Connections pane has been called …

Open the Queries and Connections Pane Wider Read More

Pass an Excel Parameter to Power Query

Where has Matt been? Regular readers of my blog may have noticed I have been missing in action over the last month.  I have been super busy with the PUG World Tour, delivering a lot …

Pass an Excel Parameter to Power Query Read More

Using Variables in DAX

Level: Intermediate The variable feature in DAX has been around for more than a year and I have simply never got around to writing an article about it – I am changing that today.  Let me …

Using Variables in DAX Read More

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

DMV to Extract Measures from Power Pivot

I have written articles before about how you can extract measures from a data model using DAX Studio and also using Power Pivot Utilities.  These are both excellent tools in their own right and I …

DMV to Extract Measures from Power Pivot 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

Understanding Power Query Combine

Level: Intermediate Sometime late in 2016 Microsoft deployed a new “Combine” feature in both Power Query for Excel (Get and Transform) and also in Power BI Desktop (Get Data).  The new capability makes it easier to …

Understanding Power Query Combine Read More

Power Pivot Crashes–Another Update from Seattle

When I was at the Microsoft Data Insights Summit last week I took the opportunity to catch up with Howie Dickerman to get an update on how the bug fixing with Power Pivot for Excel …

Power Pivot Crashes–Another Update from Seattle Read More

Microsoft Announces the Return of Export to Excel

At the start of May 2017, Microsoft announced that Export to Excel/CSV would no longer be available to Power B Free users, and would not be part of the new Power BI Premium offering either. Today …

Microsoft Announces the Return of Export to Excel Read More

How to Find Overlapping Pivot Tables

A client contacted me recently and asked me to solve a problem for them.  They have a large Power Pivot Excel workbook with lots of Pivot Tables.  All was good except sometimes when they refreshed …

How to Find Overlapping Pivot Tables Read More

Which to Use – Power BI or Excel?

Level: Beginners One of my regular blog readers (and graduate of my live training course) Phil Cross asked me last week if I knew of anywhere to find a comprehensive guide for Self Service BI …

Which to Use – Power BI or Excel? Read More

Scroll to Top