Welcome to our Power Query blog. This week, I look at a way to reorganise data in a table by merging with itself.

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 our regular A to Z of Excel Functions blog. Today we look at the INFO function.

Welcome back to this week’s Charts and Dashboards blog series. This week, we complete our take on Bullet Charts.

Welcome back to this week’s edition of the Power BI blog series. This week, we will expand on the last week’s blog, this time with different coloured stacked column charts.

Welcome to our Power Query blog. This week, I look at a more efficient way of merging the data from last week, again when there is not a clear link between the tables

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.

On the final Friday of each month, we set an Excel / Power Pivot / Power Query / Power BI problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

On the final Friday of each month, we’re going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you’re playing for bragging rights only!

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create different coloured columns in a column chart.