Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

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.


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

24 December 2019

Welcome back to the Power Pivot Principles blog. This week, we are going to look at an example of applying functions for parent-child hierarchies in a business case.


Power Pivot Principles: Introducing the Function LOOKUPVALUE

17 December 2019

Welcome back to the Power Pivot Principles blog. Before we learn more functions for parent-child hierarchies in DAX, this week, we are going to look aside at one function of looking up values in DAX.


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

10 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.


Newsletter