Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

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.


Power Pivot Principles: Highlighting Absent Students

27 August 2019

Welcome back to our Power Pivot blog. Today, we look at how to create a PivotChart that highlights the number of absent students in university classes.


Power Pivot Principles: Dynamic Ranges and Periods for Rolling Averages

20 August 2019

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept, first introduced in a previous blog, and show you how to include a dynamic period selection range in a rolling average measure.


Power Pivot Principles: Dynamic Ranges for Rolling Averages

13 August 2019

Welcome back to our Power Pivot blog. Today, we expand on the rolling average concept first introduced in a previous blog and show you how to include a dynamic selection range to a rolling average measure.


Power Pivot Principles: Introducing the LASTDATE Function

6 August 2019

Welcome back to our Power Pivot blog. Today, we show you how the LASTDATE function work.


Power Pivot Principles: Introducing the DATESINPERIOD Function

30 July 2019

Welcome back to our Power Pivot blog. Today, we show you how the DATESINPERIOD function works.


Power Pivot Principles: Dynamic Ranking based on Selection Filters

23 July 2019

Welcome back to our Power Pivot blog. Today, we show you how to create a dynamic ranking measure that changes based on selection filters.


Newsletter