Power Pivot Principles

Subscribe via RSS

Power Pivot Principles: Introducing the NOT Function

28 May 2019

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

Power Pivot Principles: Introducing the SWITCH Function

21 May 2019

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

Power Pivot Principles: Introducing the MEDIANX Function

14 May 2019

Welcome back to our Power Pivot blog. Today, we look at the MEDIANX function.

Power Pivot Principles: Introducing the MEDIAN Function

7 May 2019

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

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

Power Pivot Principles

Request a free assessment