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 will show you how to label periods on a visual.

Welcome to our Power Query blog. Today, I look at a slightly different problem where I need to divide amounts over rows.

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

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

This week in our series about Microsoft Excel for Mac, we show how to work around the missing feature, Evaluate Formula, by using a new feature and some old-school technique.

Welcome back to this week’s edition of the Power BI blog series. This week, we look the Narrative Visual with Copilot – an update to the well-liked Smart Narratives.

Welcome to our Power Query blog. Today, I refine a solution to a problem where I need to divide amounts over rows.

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

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