Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Introducing the SAMEPERIODLASTYEAR Function

5 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the function SAMEPERIODLASTYEAR function.


Power Pivot Principles: Power Pivot Principles : Creating a Calendar Table

29 October 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to provide a refresher regarding creating a calendar table.


Power Pivot Principles: Introducing the SUMMARIZE Function

22 October 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the SUMMARIZE function.


Power Pivot Principles: Power Pivot Principles : Introducing the HASONEVALUE Function

15 October 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new function, HASONEVALUE.


Power Pivot Principles: Properly Calculating Weighted Totals with the ISFILTERED Function

8 October 2019

Welcome back to our Power Pivot blog. Today, we look at the ISFILTERED function.


Power Pivot Principles: Introducing the SUBSTITUTE Function

1 October 2019

Welcome back to our Power Pivot blog. Today, we look at the SUBSTITUTE function.


Power Pivot Principles: Introducing the REPLACE Function

24 September 2019

Welcome back to our Power Pivot blog. Today, we look at the REPLACE function.


Power Pivot Principles: Calculating Cumulative Totals with Variables

17 September 2019

Welcome back to our Power Pivot blog. Today, we look at an alternative method of calculating cumulative sums without using the EARLIER function.


Power Pivot Principles: Cumulative Totals with the EARLIER Function

10 September 2019

Welcome back to our Power Pivot blog. Today, we look at another application of the EARLIER function.


Power Pivot Principles: Introducing the EARLIER Function

3 September 2019

Welcome back to our Power Pivot blog. Today, we look at the EARLIER function.


Newsletter