Power Pivot Principles

Power Pivot Principles: How to Create the CAGR Measure, Part 2

19 March 2019

Welcome back to our Power Pivot blog. We continue on our CAGR series: today, we shall look into fixing our measures so we can calculate CAGR.

Power Pivot Principles: How to Create the CAGR Measure, Part 1

12 March 2019

Welcome back to our Power Pivot blog. Today, we begin a short series on how to create the CAGR measure in Power Pivot.

Power Pivot Principles: Introducing the DIVIDE Function

5 March 2019

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

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

Power Pivot Principles

Request a free assessment