Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Irregular Month-End Reporting Case – Part 6

22 September 2020

Welcome back to the Power Pivot Principles blog. This week, we will look at an alternative way to calculate the All Year Sales in our seemingly never-ending case study.


Power Pivot Principles: Irregular Month-End Reporting Case – Part 5

15 September 2020

Welcome back to the Power Pivot Principles blog. This week, we will be considering the penultimate steps in our irregular month-end reporting case study.


Power Pivot Principles: Irregular Month-End Reporting Case – Part 4

8 September 2020

Welcome back to the Power Pivot Principles blog. This week, we still continue with our irregular month-end reporting case study.


Power Pivot Principles: Irregular Month-End Reporting Case – Part 3

1 September 2020

Welcome back to the Power Pivot Principles blog. This week, we continue with our irregular month-end reporting case study.


Power Pivot Principles: Irregular Month-End Reporting Case – Part 2

25 August 2020

Welcome back to the Power Pivot Principles blog. This week, we will continue with our irregular month-end reporting case study.


Power Pivot Principles: Irregular Month-End Reporting Case – Part 1

18 August 2020

Welcome back to the Power Pivot Principles blog. Over the next few weeks, we will cover a case study related to an irregular month-end reporting rule.


Power Pivot Principles: HASONEFILTER vs. HASONEVALUE vs. ISFILTERED

11 August 2020

Welcome back to the Power Pivot Principles blog. This week, we will compare the HASONEFILTER function to the HASONEVALUE and ISFILTERED functions in DAX.


Power Pivot Principles: Introducing the HASONEFILTER Function

4 August 2020

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


Power Pivot Principles: ISCROSSFILTERED vs ISFILTERED Functions

28 July 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the difference between the ISCROSSFILTERED and the ISFILTERED functions in DAX.


Power Pivot Principles: Introducing the FILTERS Function

21 July 2020

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


Newsletter