Please note javascript is required for full website functionality.

Blog

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

10 December 2024

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


A to Z of Excel Functions: The ROUND Function

9 December 2024

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


Excel for Mac: VBA and the VB Editor on Mac

6 December 2024

This week in our series about Microsoft Excel for Mac, we cover differences in VBA and the VB Editor in Excel for Mac. The short story is that most things work: some are a little different and some things are just not possible.


Power BI Blog: Quick Measures Update

5 December 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we note that Quick Measure Suggestions with Copilot is to be replaced with Microsoft Fabric Copilot.


Power Query: Fuzzy Fixing Part 3

4 December 2024

Welcome to our Power Query blog. This week, I look at a larger data set with more variants that need to the fixed.


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

3 December 2024

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


Monday Morning Mulling: November 2024 Challenge

2 December 2024

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish one suggested solution. No-one is stating this is the best approach, it’s just the one we selected. If you don’t like it, lump it – or contact us with your preferred solution. This past Friday, we presented you with the Staircase Challenge.


Final Friday Fix: November 2024 Challenge

29 November 2024

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: Power BI Report Creation with Copilot

28 November 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we consider creating reports with Copilot, currently in Preview.


Power Query: Fuzzy Fixing Part 2

27 November 2024

Welcome to our Power Query blog. This week, I continue to fix data that is almost correct!


Newsletter