Please note javascript is required for full website functionality.

Blog

Excel for Mac: Power Query and PivotTables – Consolidate Ranges

16 February 2024

This week in our series about Microsoft Excel for Mac, we show you a better way to create a PivotTable with data from several ranges, sometimes called a Consolidated Range PivotTable.


Power BI Blog: Suggested Synonyms from Copilot

15 February 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at Copilot sticking its oar in and suggesting synonyms.


Power Query: Heading Off – Part 1

14 February 2024

Welcome to our Power Query blog. Today, I begin to look at an issue that occurs when I load to a Table with no headers.


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

13 February 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 GEOMEAN.


A to Z of Excel Functions: The DATESTRING Function

12 February 2024

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


Excel for Mac: Power Query – From Table/Range

9 February 2024

This week in our series about Microsoft Excel for Mac, we show an easy way to give more power to Power Query in Excel for Mac. As of November 2023, Power Query on Mac does not have a button on the Data tab to let you start a query from a table or range in the current workbook. No problem! Keep reading to find out how to create such queries without the button.


Power BI Blog: Explore in Power BI Service

8 February 2024

Welcome back to this week’s edition of the Power BI blog series. This week, we look at the new Explore feature in Power BI Service.


Power Query: Equal Split Part 5

7 February 2024

Welcome to our Power Query blog. Today, I continue to modify the solution to divide amounts over rows by using a parameter.


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

6 February 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 GENERATESERIES.


A to Z of Excel Functions: The PROB Function

5 February 2024

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


Newsletter