Please note javascript is required for full website functionality.

Blog

Excel for Mac: Power Query – Creating Data Types

7 March 2025

This week in our series about Microsoft Excel for Mac, we show an easy way to overcome a limitation of Power Query in Excel for Mac. As of February 2025, Power Query on Mac does not have the ‘Create Data Type’ button. No problem! Keep reading to find out how to create data types without the button.


Power BI Blog: Text Slicer Improvements

6 March 2025

Welcome back to this week’s edition of the Power BI blog series. This week, we look how a Text slicer may now accept multiple values.


Power Query: A Tangled Web Part 2

5 March 2025

Welcome to our Power Query blog. This week, I load the web data I extracted last time to the Power Query editor.


Power Pivot Principles: The A to Z of DAX Functions – INFO.RELATIONSHIPINDEXSTORAGES

4 March 2025

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


Monday Morning Mulling: February 2025 Challenge

3 March 2025

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.


Final Friday Fix: February 2025 Challenge

28 February 2025

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.


Power BI Blog: Semantic Model Version History in Preview

27 February 2025

Welcome back to this week’s edition of the Power BI blog series. This week, review the semantic model version history, currently in public Preview.


Power Query: A Tangled Web Part 1

26 February 2025

Welcome to our Power Query blog. This week, I use the ‘Add Table Using Examples’ functionality to create custom tables from web data.


Power Pivot Principles: The A to Z of DAX Functions – INFO.RELATEDCOLUMNDETAILS

25 February 2025

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


A to Z of Excel Functions: The RSQ Function

24 February 2025

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


Newsletter