Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Introducing the Function CROSSFILTER

3 March 2020

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


Power Pivot Principles: Parameter Table

25 February 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a way to introduce a parameter table into Power Pivot.


Power Pivot Principles: Bidirectional Relationships in Power Pivot

18 February 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to talk about relationships in Power Pivot.There are three different possible physical relationship types in database design but not all supported in Power Pivot. The major types of relationship...


Power Pivot Principles: Introducing the Function PARALLELPERIOD

11 February 2020

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


Power Pivot Principles: Introducing the Function CROSSJOIN

3 February 2020

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


Power Pivot Principles: Introducing the Function DISTINCTCOUNT

28 January 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method to derive the unique values in a column by using DAX.


Power Pivot Principles: Introducing the Function INTERSECT

21 January 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn one way of joining tables together in DAX.


Power Pivot Principles: Counting Working Days

14 January 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method to calculate the working days using PowerPivot.


Power Pivot Principles: Introducing the DATESBETWEEN Function

7 January 2020

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


Power Pivot Principles: Introducing the ADDCOLUMNS Function

31 December 2019

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


Newsletter