Please note javascript is required for full website functionality.

Blog

Power Query: Web Grouping

8 February 2023

Welcome to our Power Query blog. This week, I investigate grouping queries in Excel for the Web.


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

7 February 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 DATESBETWEEN.


A to Z of Excel Functions: The NORMSINV Function

6 February 2023

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


Charts and Dashboards: The Risk Bubble Chart – Part 3

3 February 2023

Welcome back to our Charts and Dashboards blog series. This week, we move into Week 3 of looking at how to make a Risk Bubble chart.


Power BI Blog: Linked Metrics

2 February 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we consider linked metrics.


Power Query: Refreshing Challenges on the Web – Part 2

1 February 2023

Welcome to our Power Query blog. This week, I continue investigating refreshing queries in Excel for the Web by looking at an example with a query and a PivotTable.


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

31 January 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 DATEDIFF.


Monday Morning Mulling: January 2023 Challenge

30 January 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.


Final Friday Fix: January 2023 Challenge

27 January 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: Creating Dynamic Slicers using Field Parameters

26 January 2023

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to create dynamic slicers using field parameters.


Newsletter