Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Finding the Top N Values in a Dataset

21 April 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method of finding the top N value in a dataset.


Power Pivot Principles: Using DAX Studio to Return a Table Expression

14 April 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to talk about the DAX Studio and compare it with the old way of returning a table expression in Power Pivot.


Power Pivot Principles: Introducing the Function FIRSTNONBLANK

7 April 2020

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


Power Pivot Principles: Using USERELATIONSHIP to Activate an Inactive Relationship

31 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method of creating a virtual relationship in Power Pivot.


Power Pivot Principles: Using SELECTCOLUMNS to Create Calendar Table

24 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new way of using a DAX function to create a calendar table.


Power Pivot Principles: Using ADDCOLUMNS to Create a Calendar Table

17 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a way of using a DAX function to create a calendar table.


Power Pivot Principles: Ambiguity of Bidirectional Relationships in Power BI

10 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to talk about the ambiguity of bidirectional relationships in Power BI.


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


Newsletter