Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Understanding Functions for Parent-Child Hierarchies in DAX – Part 2

3 December 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at another function for parent-child hierarchies in DAX.


Power Pivot Principles: Understanding functions for parent-child hierarchies in DAX – Part 1

26 November 2019

Welcome back to the Power Pivot Principles blog. Start from this week, we are going to understand some functions for parent-child hierarchies in DAX.


Power Pivot Principles: Introducing the CROSSFILTER Function

19 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to introduce a new function CROSSFILTER.


Power Pivot Principles: Selecting from Multiple Lookup Values

12 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to introduce a method to extract a single value from the group text columns.


Power Pivot Principles: Introducing the SAMEPERIODLASTYEAR Function

5 November 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the function SAMEPERIODLASTYEAR function.


Power Pivot Principles: Power Pivot Principles : Creating a Calendar Table

29 October 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to provide a refresher regarding creating a calendar table.


Power Pivot Principles: Introducing the SUMMARIZE Function

22 October 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at the SUMMARIZE function.


Power Pivot Principles: Power Pivot Principles : Introducing the HASONEVALUE Function

15 October 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new function, HASONEVALUE.


Power Pivot Principles: Properly Calculating Weighted Totals with the ISFILTERED Function

8 October 2019

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


Power Pivot Principles: Introducing the SUBSTITUTE Function

1 October 2019

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


Newsletter