Please note javascript is required for full website functionality.

Blog

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.


Final Friday Fix: February 2023 Challenge

2 February 2023

On the final Friday of each month, we are going to set an Excel / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are playing for bragging rights only!


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.


Power Query: Refreshing Challenges on the Web – Part 1

25 January 2023

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


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

24 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 DATEADD.


Newsletter