Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Drawing a BLANK on Error Traps

8 May 2018

How to include error traps in our measure formulae.


Power Pivot Principles: Measure Creation in Practice

1 May 2018

Today we discuss proper practices we should adopt when creating measures.


Power Pivot Principles: Recognising Measures

24 April 2018

Welcome back to our Power Pivot blog series. Today we discuss how to tell the difference between a measure and a field.



Power Pivot Principles: Calculated Columns

10 April 2018

Welcome back to our Power Pivot blog. Today, we consider how to create a calculated column.


Power Pivot Principles: Tables, Fields and Measures

3 April 2018

Today let’s go over the syntax between a table, a field, and a measure.


Power Pivot Principles: Power Pivot Menu in Excel

27 March 2018

To conclude our series covering menu tabs, we will cover the Power Pivot menu options in Excel.


Power Pivot Principles: Advancing the Series

20 March 2018

Welcome back to our Power Pivot blog series. In the previous two blogs we’ve covered the ‘Home’ tab, and the ‘Design’ tab, can you guess what’s next?


Power Pivot Principles: A Design for Life

13 March 2018

oday, we consider some of the menu options in the Power Pivot window, focusing on the Design tab.


Power Pivot Principles: Menu Options

6 March 2018

Today we consider some of the various menu options in the Power Pivot window...


Newsletter