Power Pivot Principles

Power Pivot Principles: Dynamic Ranking based on Selection Filters

23 July 2019

Welcome back to our Power Pivot blog. Today, we show you how to create a dynamic ranking measure that changes based on selection filters.

Power Pivot Principles: Introducing the RANKX Function

16 July 2019

Welcome back to our Power Pivot blog. Today, we show you how use set up slicers to dynamically segregate text data based on text inputs.

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

9 July 2019

Welcome back to our Power Pivot blog. Today, we show you how use set up slicers to dynamically segregate text data based on text inputs.

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

Power Pivot Principles

Request a free assessment