This week in our series about Microsoft Excel for Mac, it’s all about Power Query. For a long time, it didn’t even exist on Mac, but since it’s such a key feature of Excel, the team at Microsoft has been steadily introducing more and more Power Query capability to Excel for Mac. At the time of writing, it’s still missing a few features, but it at least has a good foundation.

On the final Friday of each month, we release a blog series called the “Final Friday Fix” where we set an Excel / Power Pivot / Power Query / Power BI problem for users to solve over the weekend. This month, we decided to experiment by creating the Final Friday Fix and its corresponding Monday Morning Mulling using the new ‘GPTs’ feature in ChatGPT. Here is how we did it and how we also reflect on how well it went.

Welcome back to this week’s edition of the Power BI blog series. This week, we will complete building the combo visual that highlights event periods.

Welcome to our Power Query blog. Today, I modify the solution to divide amounts over rows by using a parameter.

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

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