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.

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...

On the final Friday of each month, we are 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 are...

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at the Decomposition Tree visualisation.

Welcome to our Power Query blog. This week, I look at some ways to make merges more efficient.

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

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to build the “conditional donut chart”.

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will look at ordering the legend in visualisations.

Welcome to our Power Query blog. This week, I look at solving a problem with a nested join and the M function Table.Buffer().