Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: PREVIOUSMONTH Comparison

11 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data using yet another approach.


Power Pivot Principles: PARALLELPERIOD Comparison

4 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data again, but this time using on an alternative approach.


Power Pivot Principles: DATEADD Comparison

27 April 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to work on an alternate approach from last week to compare monthly data.


Power Pivot Principles: Annual / Monthly Comparisons

20 April 2021

Welcome back to the Power Pivot Principles blog. This week, I will be comparing my Actuals data for different years.


Power Pivot Principles: Slicing the Bridge

13 April 2021

Welcome back to the Power Pivot Principles blog. This week, we will create a slicer to filter out the summary table.


Power Pivot Principles: How Did I Bridge the Gaps?

6 April 2021

Welcome back to the Power Pivot Principles blog. By popular demand, I will revisit last week’s scenario and show you how to build a so-called “bridging table”.


Power Pivot Principles: Bridging the Gaps

30 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll talk about linking the Budget and Transaction tables in the data set we have been working on.


Power Pivot Principles: Data Cleansing

25 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll talk about some of the inabilities of Power Pivot when it comes to organising data in a meaningful manner.


Power Pivot Principles: Credit Transactions

16 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll continue where we left off last week, revealing “the truth” about the different negative and positive values.


Power Pivot Principles: Budget vs Actuals

9 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll create a quarterly Budget vs Actuals table based on different Account aggregation.


Newsletter