Power Pivot Principles

Subscribe via RSS

Power Pivot Principles: MAXX with Filter Criteria

30 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to include filters in the MAXX function.

Power Pivot Principles: MAXX

23 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use the MAXX function.

Power Pivot Principles: Conditional Custom Columns with Four Categories

16 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns using the AND ‘&&’ and OR ‘||’ operators together.

Power Pivot Principles: Conditional Custom Columns Using IF, OR and ‘||’

9 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns with multiple criteria… again.

Power Pivot Principles: Conditional Custom Columns Using IF, AND, and ‘&&’

2 April 2019

Welcome back to our Power Pivot blog. Today, we discuss how to create conditional custom columns with multiple criteria.

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

26 March 2019

Welcome back to our Power Pivot blog. We continue on our CAGR series. Today, we shall look into making our CAGR measure more dynamic and discuss additional improvements to the measures.

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

Power Pivot Principles

Request a free assessment