Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: Introducing ALL

12 June 2018

Welcome back to our Power Pivot blog. Today we discuss how to use the ALL function in DAX.


Power Pivot Principles: Caution when Negating Formulae

5 June 2018

Welcome back to our Power Pivot blog. Today we discuss negating formulas in Power Pivot.


Power Pivot Principles: Doing More with CALCULATE

29 May 2018

Can we use more than one criteria with the CALCULATE function?


Power Pivot Principles: Introducing CALCULATE

22 May 2018

Welcome back to our Power Pivot blog series. Today we discuss a function that we can use in developing measures.


Power Pivot Principles: Power PivotTables

15 May 2018

After importing data into Power Pivot, we may wish to create a PivotTable.


Power Pivot Principles: Drawing a BLANK on Error Traps

8 May 2018

How to include error traps in our measure formulae.


Power Pivot Principles: Measure Creation in Practice

1 May 2018

Today we discuss proper practices we should adopt when creating measures.


Power Pivot Principles: Recognising Measures

24 April 2018

Welcome back to our Power Pivot blog series. Today we discuss how to tell the difference between a measure and a field.



Power Pivot Principles: Calculated Columns

10 April 2018

Welcome back to our Power Pivot blog. Today, we consider how to create a calculated column.


Newsletter