Please note javascript is required for full website functionality.

Blog

Power BI Blog: Visual Calculations Updated

7 November 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we revisit Visual Calculations, which have recently been updated.


Power Query: It’s Good to Share(Point) Part 7

6 November 2024

Welcome to our Power Query blog. This week, I look at extracting data from a SharePoint list.


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

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


A to Z of Excel Functions: The REPT Function

4 November 2024

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


Excel for Mac: Built-in Add-ins

1 November 2024

This week in our series about Microsoft Excel for Mac, we discuss built-in Excel add-ins, which have some differences between Windows and Mac.


Power BI Blog: Power BI in Teams Now Supporting Multi Factor Authentication

31 October 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Multi Factor Authentication for Power BI in Teams.


Power Query: It’s Good to Share(Point) Part 6

30 October 2024

Welcome to our Power Query blog. This week, I look at another way to extract data from a folder on SharePoint.


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

29 October 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.KPIS.


Monday Morning Mulling: October 2024 Challenge

28 October 2024

On the final Friday of each month, set a challenge in Excel for you to solve over 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.


Final Friday Fix: October 2024 Challenge

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


Newsletter