Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: When the CALCULATE Function Misbehaves.

8 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to stop the CALCULATE function from overwriting row filters.


Power Pivot Principles: Lookups in Power Pivot

18 December 2018

Welcome back to our Power Pivot blog. Today, we discuss how to create lookups in Power Pivot.


Power Pivot Principles: How to Combine Three or More Filter Criteria into One CALCULATE Measure

11 December 2018

Welcome back to our Power Pivot blog. Today, we dive a little deeper into the IN function.


Power Pivot Principles: Concatenating Filters

4 December 2018

Welcome back to our Power Pivot blog. Today, we look at using concatenation with the FILTER function to combine filter criteria.


Power Pivot Principles: Introducing the IN Function

27 November 2018

Welcome back to our Power Pivot blog. Today, we discuss the IN function, one of the several logical functions in Power Pivot.


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.


Newsletter