Power Pivot Principles

Subscribe via RSS

Power Pivot Principles: Introducing the CALCULATETABLE Function

26 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the CALCULATETABLE Function.

Power Pivot Principles: Introducing the SUMX function

19 February 2019

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

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

Power Pivot Principles

Request a free assessment