Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Calculating Measures

9 February 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll examine an example of how to convert a field to a measure.


Power Pivot Principles: Summarising a Budget

2 February 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll examine an example of how to summarise a company’s budget in Power Pivot.


Power Pivot Principles: Hiding Subtotals

26 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will share a tip on how to hide subtotals in a PivotTable.


Power Pivot Principles: Slicers for Columns – Part 2

19 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will continue to talk about slicers for columns.


Power Pivot Principles: Slicers for Columns – Part 1

12 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will talk about creating slicers for columns.


Power Pivot Principles: SWITCH the Slicer

5 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will discuss about using slicers with the SWITCH function.


Power Pivot Principles: More PivotCharts from the Power Pivot Data Model

29 December 2020

Welcome back to the Power Pivot Principles blog. This week, we will continue with looking at creating PivotCharts from the Power Pivot Data Model.


Power Pivot Principles: Creating PivotCharts from the Power Pivot Data Model

22 December 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about creating PivotCharts from the Power Pivot Data Model.1479


Power Pivot Principles: Size Can Be Everything

15 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a very simple trick we realise we take for granted.


Power Pivot Principles: Nothing to Draw a BLANK About – ISBLANK Zero?

8 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a common mistake made with zero(e)s.


Newsletter