Welcome to our Power Query blog. Today, I begin to look at an issue that occurs when I load to a Table with no headers.

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

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

This week in our series about Microsoft Excel for Mac, we show an easy way to give more power to Power Query in Excel for Mac. As of November 2023, Power Query on Mac does not have a button on the Data tab to let you start a query from a table or range in the current workbook. No problem! Keep reading to find out how to create such queries without the button.

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Explore feature in Power BI Service.

Welcome to our Power Query blog. Today, I continue to 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 GENERATESERIES.

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

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.