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

Welcome to our Power Query blog. Today, I consider a challenge involving a choice of filters, and I begin by extracting and transforming the input 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.CATALOGS.

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

This week in our series about Microsoft Excel for Mac, we show how to create a forecast sheet, even though the ‘Forecast Sheet’ feature isn’t available on Mac.

This week, we revisit creating multiple ToolTips for one visual. Since the Power BI interface has been undergoing some transformations, we aim to provide a clear route to access this functionality.

Welcome to our Power Query blog. Today, I complete the challenge.

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

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