Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Calculated Field vs. Measure

8 June 2021

Welcome back to the Power Pivot Principles blog. This week, we consider the differences between creating a calculated field and a calculated measure.


Power Pivot Principles: Initial Measures – a Pro Tip

1 June 2021

Welcome back to the Power Pivot Principles blog. This week, we explain the advantages of creating measures from fields. Who’d have thought..?


Power Pivot Principles: COGS and COGS Cash Payments

25 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going calculate Cost of Goods Sold and cash payments for Cost of Goods Sold.


Power Pivot Principles: PREVIOUSQUARTER Comparison

18 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare quarterly data using a new Power Pivot function.


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”.


Newsletter