Please note javascript is required for full website functionality.

Blog

Excel for Mac: Should You Buy a Mac?

5 January 2024

This week in our series about Microsoft Excel for Mac, we’ll point out some important features that aren’t available Excel for Mac, which should help you decide whether a Mac is right for you.


Power BI Blog: Power BI Desktop – One Drive and SharePoint Integration

4 January 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to edit One Drive and SharePoint integration for Power BI Desktop.


Power Query: Blog List – Part 6

3 January 2024

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I welcome some new functionality, currently in Preview, which will allow me to achieve my goal in Power Query in Excel.


Power Pivot Principles: The A to Z of DAX Functions – FORMAT

2 January 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 FORMAT.


Monday Morning Mulling: December 2023 Challenge

1 January 2024

Happy New Year! 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 following 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, but we do appreciate your enthusiasm!


Final Friday Fix: December 2023 Challenge

29 December 2023

We hope you’re having a great Christmas break! 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 following 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, but we do appreciate your enthusiasm!


Power BI Blog: De-duplication Rules for Composite Models

28 December 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we review whether Microsoft should make up words such as “de-duplication”. Or maybe that isn’t what this article is about – perhaps it’s about preventing duplication for composite models on Power BI Datasets and Analysis Services.


Power Query: Blog List – Part 5

27 December 2023

Welcome to our Power Query blog. I would like to get a list of all the Power Query blogs I have posted. Today, I look at why the method I used required Power Query in Power BI.


Power Pivot Principles: The A to Z of DAX Functions – FLOOR

26 December 2023

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


A to Z of Excel Functions: The PPMT Function

25 December 2023

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


Newsletter