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.

Welcome back to the Power Pivot Principles blog. This week, we’ll examine an example of how to convert a field to a measure.

Welcome back to the Power Pivot Principles blog. This week, we’ll examine an example of how to summarise a company’s budget in Power Pivot.

Welcome back to the Power Pivot Principles blog. This week, we will share a tip on how to hide subtotals in a PivotTable.