Power Pivot Principles

Power Pivot Principles: Tips on Calculated Columns

16 October 2018

Welcome back to our Power Pivot blog. Today, we discuss some tips and best practices you should keep in mind when working with Calculated columns.

9 October 2018

Welcome back to our Power Pivot blog. Today, we discuss why it is important to have Contiguous Dates in a calendar table.

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.