Please note javascript is required for full website functionality.

Blog

Excel for Mac: Conditional Formatting

6 September 2024

This week in our series about Microsoft Excel for Mac, we show how to set up conditional formatting, and how it’s different from what you might be familiar with on Windows.


Power BI Blog: DAX Query View in the Web

5 September 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we review the DAX query view in the web.


Power Query: Filtering of Choice Part 2

4 September 2024

Welcome to our Power Query blog. This week, I continue to work on a challenge involving a choice of filters by transforming P_Choice.


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

3 September 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.EXPRESSIONS.


Monday Morning Mulling: August 2024 Challenge

2 September 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.


Final Friday Fix: August 2024 Challenge

30 August 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: Ask Copilot Questions Against Your Semantic Model

29 August 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we question Copilot.


Power Query: Filtering of Choice Part 1

28 August 2024

Welcome to our Power Query blog. Today, I consider a challenge involving a choice of filters, and I begin by extracting and transforming the input data.


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

27 August 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.CATALOGS.


A to Z of Excel Functions: The REGEXEXTRACT function

26 August 2024

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


Newsletter