Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

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.


Power Pivot Principles: Multiple Table Management

17 July 2018

Welcome back to our Power Pivot blog. Today, we discuss managing multiple tables.


Power Pivot Principles: Filters

10 July 2018

Welcome back to our Power Pivot blog. Today, we discuss how to use filters in Power Pivot.


Newsletter