Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Introducing the DATEADD Function

20 November 2018

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


Power Pivot Principles: DAX Syntax Requirements – Naming Conventions

13 November 2018

Welcome back to our Power Pivot blog. Today, we go over the DAX syntax naming requirements and conventions when it comes to tables, columns and measures.


Power Pivot Principles: DAX Requirements – Fully Qualified Names

6 November 2018

Welcome back to our Power Pivot blog. Today, we go over when to use fully qualified names.


Power Pivot Principles: Resource Management with Calculated Columns

30 October 2018

Welcome back to our Power Pivot blog. Today, we discuss factors to consider when creating and using Calculated Columns.


Power Pivot Principles: Perspectives

23 October 2018

Welcome back to our Power Pivot blog. Today, we discuss how to create and use Perspectives in PowerPivot.


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.


Power Pivot Principles: Importance of Contiguous Dates

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.


Power Pivot Principles: Introducing the CLOSINGBALANCEMONTH Function

2 October 2018

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


Power Pivot Principles: How to Refresh Data in Power Pivot

25 September 2018

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


Power Pivot Principles: Introducing the TOTALYTD Function

18 September 2018

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


Newsletter