Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

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.


Power Pivot Principles: The A to Z of DAX Functions – ADDCOLUMNS

20 July 2020

In our long-established Power Pivot Principles articles, we are starting a new series on the A to Z of Data Analysis eXpression (DAX) functions. This week we’re building on what we have so far…


Power Pivot Principles: Introducing the FILTER Function

14 July 2020

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


Power Pivot Principles: Introducing the PREVIOUSDAY / MONTH / QUARTER / YEAR Functions

7 July 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about the group of PREVIOUSDAY / MONTH / QUARTER / YEAR functions in DAX.


Newsletter