Power Pivot Archives • My Online Training Hub

May 12, 2026

Power Pivot vs PivotTables

Most PivotTables are built from one flat table. That works… until your data stops being flat. In real-world datasets, customers

November 19, 2024

Excel PivotTables are fantastic for basic analysis, but they have limitations, particularly when working with large datasets or multiple data

February 3, 2022

Some might say that Excel CUBE functions are the new PivotTables because they allow us to build reports based on

January 13, 2022

DAX is the Power Pivot formula language available in both Power BI and Excel. It stands for Data Analysis eXpression.

November 25, 2021

Power Pivot course member, Peter, asked if it was possible to toggle the top n with a Slicer for a

July 15, 2021

In this tutorial we’ll look at how to create a Power Pivot running total that allows you to see the

March 31, 2021

Ordinarily when you want to create a table in Power Query, Power Pivot or PBI, you'd write a query to

January 28, 2021

You may be familiar with Custom Format Strings in Excel, if you are not then check this Excel Custom Number

March 14, 2019

The GETPIVOTDATA function divides Excel users. You either love it or hate it, but there are good reasons for learning

March 7, 2019

Occasionally you may want to show values as percentage of another PivotTable column total. For example, below we want to

February 12, 2019

With disconnected tables in Power Pivot* we can change PivotChart aggregation methods using Excel Slicers. It allows us to create

April 3, 2017

With the integration of Power Pivot into Excel 2013 (known as the Data Model), we now have access to a

June 22, 2016

If you use Excel PivotTables then you’re probably familiar with the need to consolidate data from multiple tables into a

May 25, 2016

One of the most common questions I get is, what’s the difference between Power Query and Power Pivot and when

October 27, 2015

Unfortunately there’s no built in way to calculate the median in a PivotTable. The approach is different depending on whether

September 29, 2014

Excel PivotTable Named Sets enable you to pick and choose which columns or rows you want included in your PivotTable