Please note javascript is required for full website functionality.

Power Pivot Principles

Power Pivot Principles

Power Pivot Principles: SWITCH the Slicer

5 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will discuss about using slicers with the SWITCH function.


Power Pivot Principles: More PivotCharts from the Power Pivot Data Model

29 December 2020

Welcome back to the Power Pivot Principles blog. This week, we will continue with looking at creating PivotCharts from the Power Pivot Data Model.


Power Pivot Principles: Creating PivotCharts from the Power Pivot Data Model

22 December 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about creating PivotCharts from the Power Pivot Data Model.1479


Power Pivot Principles: Size Can Be Everything

15 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a very simple trick we realise we take for granted.


Power Pivot Principles: Nothing to Draw a BLANK About – ISBLANK Zero?

8 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a common mistake made with zero(e)s.


Power Pivot Principles: Problems with 1 Month Ago – DATEADD vs. PREVIOUSMONTH

1 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look back at, er, looking back and an associated classic gotcha.


Power Pivot Principles: Getting the Measure of a Measure – Multiple Measure Management

24 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will consider where to store measures when you have many measures and tables in your database.


Power Pivot Principles: Using Measures to Define Target Value in KPIs

17 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using measures to define target values for KPIs.


Power Pivot Principles: Introduction to Key Performance Indicators (KPIs) in Power Pivot

10 November 2020

Welcome back to the Power Pivot Principles blog. So far, we have discussed only about using measures in Power Pivot. This week, we will move away from measures and talk about Key Performance Indicators (KPIs).


Power Pivot Principles: Working with Averages – Part 2

3 November 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about using the AVERAGEX function when working with averages in DAX.


Newsletter