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 look at conditional formatting support for visual calculation in Power BI.

Welcome to our Power Query blog. This week, I complete my series looking at the M code produced when extracting data from the web.

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

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

Welcome back to our weekly AI blog. Today, we start taking a more in depth look at the AI tool that has recently captured so much public attention.

Welcome back to this week’s edition of the Power BI blog series. This week, we note the latest enhancements to the Treemap visual.

Welcome to our Power Query blog. This week, I look at the M code created when I extract web data using ‘Add Table Using Examples’.

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

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