Power Pivot Principles

Power Pivot Principles: Introducing the CLOSINGBALANCEMONTH Function

2 October 2018

Welcome back to our Power Pivot blog. Today, we introduce the CLOSINGBALANCEMONTH function.

25 September 2018

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

18 September 2018

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

11 September 2018

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

4 September 2018

Welcome back to our Power Pivot blog. Today, we discuss the steps we should take when creating a 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.

21 August 2018

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

14 August 2018

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

7 August 2018

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

31 July 2018

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