Power Pivot Principles

Power Pivot Principles: Grouping Text Columns with New Categories Dynamically using an Input Table

2 July 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use an input Table to group text columns into new categories

Power Pivot Principles: Introducing the LASTNONBLANK Function

25 June 2019

Welcome back to our Power Pivot blog. Today, we will go over how to use the LASTNONBLANK function.

Power Pivot Principles: Grouping Text Columns with New Categories

18 June 2019

Welcome back to our Power Pivot blog. Today, we will use the SEARCH and SWITCH functions to create custom columns that group text columns into new categories.

Power Pivot Principles: Introducing the SEARCH Function

11 June 2019

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

Power Pivot Principles: Introducing the CONCATENATE Function

4 June 2019

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

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

Power Pivot Principles

Request a free assessment