Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: How to Refresh Data in Power Pivot

25 September 2018

Welcome back to our Power Pivot blog. Today, we go over how to refresh data in Power Pivot.


Power Pivot Principles: Introducing the TOTALYTD Function

18 September 2018

Welcome back to our Power Pivot blog. Today, we introduce another time intelligence function.


Power Pivot Principles: Introducing the DATESYTD Function

11 September 2018

Welcome back to our Power Pivot blog. Today, we introduce one our first time intelligence functions.


Power Pivot Principles: Basic Use of Calendar Table

4 September 2018

Welcome back to our Power Pivot blog. Today, we discuss the steps we should take when creating a Calendar Table.


Power Pivot Principles: Calendar Table

28 August 2018

Welcome back to our Power Pivot blog. Today, we discuss the steps we should take when creating a Calendar Table.


Power Pivot Principles: Filters Revisited

21 August 2018

Welcome back to our Power Pivot blog. Today, we discuss another way to use Filters in Power Pivot.


Power Pivot Principles: Disconnected Tables and Exchange Rates

14 August 2018

Welcome back to our Power Pivot blog. Today, we discuss why disconnected tables may be useful in Power Pivot.


Power Pivot Principles: Calculating with Other Tables

7 August 2018

Welcome back to our Power Pivot blog. Today, we discuss how the CALCULATE function can benefit from connected tables.


Power Pivot Principles: Tidying Data

31 July 2018

Welcome back to our Power Pivot blog. Today, we discuss potential steps we can take when we receive ‘messy’ data.


Power Pivot Principles: Introducing Slicers

24 July 2018

Welcome back to our Power Pivot blog. Today, we consider slicers in PivotTables created using Power Pivot.


Newsletter