Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

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.


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.


Newsletter