Please note javascript is required for full website functionality.

Blog

Final Friday Fix: November 2023 Challenge

24 November 2023

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: New Features for Editing Relationships

23 November 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we provide you with some relationship advice free of charge...


Power Query: Excel Files from a Folder Fiddle – Part 3

22 November 2023

Welcome to our Power Query blog. Today, I look at the reason behind an issue I encountered recently when importing Excel files from a folder.


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

21 November 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 FIND.


A to Z of Excel Functions: The POWER Function

20 November 2023

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


Charts and Dashboards: The Horizontal Raincloud Chart – Part 3

17 November 2023

Welcome back to our Charts and Dashboards blog series. This week, we continue to show you how to make a bespoke Horizontal Raincloud chart, by creating a Scatter chart for our error bar.


Power BI Blog: Date Hierarchy Updates

16 November 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at updates to On-object interactions regarding date hierarchies on data flyouts.


Power Query: Excel Files from a Folder Fiddle – Part 2

15 November 2023

Welcome to our Power Query blog. Today, I look at how to resolve an issue I encountered recently when importing Excel files from a folder.


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

14 November 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 FILTERS.


A to Z of Excel Functions: The POISSON.DIST Function

13 November 2023

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


Newsletter