Please note javascript is required for full website functionality.

Blog

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.


Power Query: Options for Table Groups

23 December 2020

Welcome to our Power Query blog. This week, I look closer at Table.Group(), which I used last week.


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

22 December 2020

Welcome back to the Power Pivot Principles blog. This week, we will talk about creating PivotCharts from the Power Pivot Data Model.1479


A to Z of Excel Functions: The IMSINH Function

21 December 2020

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


Charts and Dashboards: Dynamic Chart Labels

18 December 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we show you how to create dynamic chart labels.


Power BI Blog: Using Display Folders

17 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to set display folders to organise your fields and measures.


Power Query: Divided Groups

16 December 2020

Welcome to our Power Query blog. This week, I look at how to group into changes of value.


Power Pivot Principles: Size Can Be Everything

15 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a very simple trick we realise we take for granted.


Newsletter