Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: DISTINCT vs. DISTINCTCOUNT

16 June 2020

Welcome back to the Power Pivot Principles blog. This week, we will consider the differences between the DISTINCT and DISTINCTCOUNT functions in DAX.


Power Pivot Principles: Introducing the DISTINCT function

9 June 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the DISTINCT function in DAX.


Power Pivot Principles: Power Pivot Principle: Introducing the RELATEDTABLE function

2 June 2020

Welcome back to the Power Pivot Principles blog. This week, we consider the RELATEDTABLE function in DAX.


Power Pivot Principles: RELATED vs LOOKUPVALUE

26 May 2020

Welcome back to the Power Pivot Principles blog. This week, let’s discuss the difference between the RELATED and LOOKUPVALUE functions.


Power Pivot Principles: Is there anything RELATED?

19 May 2020

Welcome back to the Power Pivot Principles blog. This week, let’s talk about the RELATED function.


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.


Newsletter