Welcome back to the Power Pivot Principles blog. This week, I will be comparing my Actuals data for different years.

Welcome back to the Power Pivot Principles blog. This week, we will create a slicer to filter out the summary table.

Welcome back to the Power Pivot Principles blog. By popular demand, I will revisit last week’s scenario and show you how to build a so-called “bridging table”.

Welcome back to the Power Pivot Principles blog. This week, we’ll talk about linking the Budget and Transaction tables in the data set we have been working on.

Welcome back to the Power Pivot Principles blog. This week, we’ll talk about some of the inabilities of Power Pivot when it comes to organising data in a meaningful manner.

Welcome back to the Power Pivot Principles blog. This week, we’ll continue where we left off last week, revealing “the truth” about the different negative and positive values.

Welcome back to the Power Pivot Principles blog. This week, we’ll create a quarterly Budget vs Actuals table based on different Account aggregation.

Welcome back to the Power Pivot Principles blog. This week, we’ll perform a sensitivity analysis for different rates of Goods & Services Tax (GST) on the Sales transactions.

Welcome back to the Power Pivot Principles blog. This week, we’ll continue last week’s example, and build on the mistake of not including a Goods & Services Tax (GST) on the Sales transactions. For this week, we will create a disconnected table for GST.

Welcome back to the Power Pivot Principles blog. This week, we’ll continue last week’s example, which we are going to turn into a large case study over the next few weeks.