Please note javascript is required for full website functionality.

Blog

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!


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

26 November 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.MODEL.


A to Z of Excel Functions: The ROMAN Function

25 November 2024

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


AI Blog: Comparing AIs

22 November 2024

Welcome back to our AI blog. Today, we compare some of the AI tools available.


Power BI Blog: Teams Activity Analytics Report To Be Retired

21 November 2024

Welcome back to this week’s edition of the Power BI blog series. This week, say goodbye to the ‘Teams Activity Analytics’ report – and more importantly, what you should use instead.


Newsletter