Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Revisiting the SUM function

12 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the SUM function.


Power Pivot Principles: Variables and Disconnected Tables in Power Pivot

5 February 2019

Welcome back to our Power Pivot blog. Today, we revisit using Variables and Disconnected tables, this time in Power Pivot


Power Pivot Principles: Variables and Disconnected Tables in Power BI

29 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use a combination of disconnected tables and variables to produce unique slicers in Power BI.


Power Pivot Principles: Variables in DAX

22 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use variables in DAX.


Power Pivot Principles: KEEPFILTERS to the Rescue

15 January 2019

Welcome back to our Power Pivot blog. Today, we discuss an alternate way to keep the CALCULATE function from misbehaving.


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.


Newsletter