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.

Welcome back to this week’s edition of the Power BI blog series. This week we find out that the word “translytical” apparently exists – at least in Microsoft’s dictionary…

Welcome to our Power Query blog. This week, I look at how to combine rows of similar data.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.VIEW.COLUMNS.

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

Welcome back to our AI blog series. Last time we explored the fundamentals and workflows of AI Agents. Today, we’re taking it further, trying to build an AI Agent with zero code.

Welcome back to this week’s edition of the Power BI blog series. This week revisit the ever-improving List slicer.

Welcome to our Power Query blog. This week, I complete the task to simplify the way that I combine the file types into one result.

In our long-established Power Pivot Principles articles, we continue our series on the A to Z of Data Analysis eXpression (DAX) functions. This week, we look at INFO.VARIATIONS.

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