Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Duplicate Column Names

12 May 2020

Welcome back to the Power Pivot Principles blog. This week, we look at how to avoid creating errors when dealing with fields with similar names.


Power Pivot Principles: Accurate Totals

5 May 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to use DAX measure to obtain an accurate total.


Power Pivot Principles: Sorting Financial Year Months in Power Pivot

28 April 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method of sorting the financial year months in Power Pivot.


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.


Newsletter