Please note javascript is required for full website functionality.

Blog

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.


Excel for Mac: Power Query features and limitations

2 February 2024

This week in our series about Microsoft Excel for Mac, it’s all about Power Query. For a long time, it didn’t even exist on Mac, but since it’s such a key feature of Excel, the team at Microsoft has been steadily introducing more and more Power Query capability to Excel for Mac. At the time of writing, it’s still missing a few features, but it at least has a good foundation.


Newsletter