Please note javascript is required for full website functionality.

Blog

Power Query: New Year Function

6 January 2021

Welcome to our Power Query blog. This week, I look at an example using custom functions.


Power Pivot Principles: SWITCH the Slicer

5 January 2021

Welcome back to the Power Pivot Principles blog. This week, we will discuss about using slicers with the SWITCH function.


A to Z of Excel Functions: The IMSQRT Function

4 January 2021

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


Charts and Dashboards: Dynamic Simulation Charts

1 January 2021

Happy New Year! Welcome back to this week’s Charts and Dashboards blog series. As the first blog of the year, we will create a dynamic simulation chart.


Power BI Blog: Anomaly Detection

31 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at one of Power BI’s new features: Anomaly Detection.


Power Query: Timings

30 December 2020

Welcome to our Power Query blog. This week, I look at an example where I need to sum time.


Power Pivot Principles: More PivotCharts from the Power Pivot Data Model

29 December 2020

Welcome back to the Power Pivot Principles blog. This week, we will continue with looking at creating PivotCharts from the Power Pivot Data Model.


Monday Morning Mulling: December 2020 Challenge

28 December 2020

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: December 2020 Challenge

25 December 2020

On the final Friday of each month, we’re 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’re playing for bragging rights only!


Power BI Blog: Canvas Watermarks

24 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at one of Power BI’s new features: canvas watermarks.


Newsletter