Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

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

29 June 2021

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 it’s ACOSH with no offensive weapon in sight…


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

22 June 2021

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 it’s ACOS with no lettuce in sight…


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

15 June 2021

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. So how about take a brake and read about ABS…


Power Pivot Principles: Calculated Field vs. Measure

8 June 2021

Welcome back to the Power Pivot Principles blog. This week, we consider the differences between creating a calculated field and a calculated measure.


Power Pivot Principles: Initial Measures – a Pro Tip

1 June 2021

Welcome back to the Power Pivot Principles blog. This week, we explain the advantages of creating measures from fields. Who’d have thought..?


Power Pivot Principles: COGS and COGS Cash Payments

25 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going calculate Cost of Goods Sold and cash payments for Cost of Goods Sold.


Power Pivot Principles: PREVIOUSQUARTER Comparison

18 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare quarterly data using a new Power Pivot function.


Power Pivot Principles: PREVIOUSMONTH Comparison

11 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data using yet another approach.


Power Pivot Principles: PARALLELPERIOD Comparison

4 May 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data again, but this time using on an alternative approach.


Power Pivot Principles: DATEADD Comparison

27 April 2021

Welcome back to the Power Pivot Principles blog. This week, we are going to work on an alternate approach from last week to compare monthly data.


Newsletter