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 calculate cumulative totals based on a selection on data.

Welcome to our Power Query blog. This week, I finish my calendar creation.

Welcome back to the Power Pivot Principles blog. This week, we will discuss working with averages in DAX.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the IMPOWER function.

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to talk about Symbol Charts in dashboards.

Welcome back to this week’s edition of the Power BI blog series. This week, we look how to format negative currency values, including those infernal brackets.

Welcome to our Power Query blog. This week, I look at calendar creation.

Welcome back to the Power Pivot Principles blog. This week, we will talk about the REMOVEFILTERS function in DAX.