Please note javascript is required for full website functionality.

Blog

Power Query: I Gather That’s Right

9 December 2020

Welcome to our Power Query blog. This week, I look at how to gather data from multiple rows.


Power Pivot Principles: Nothing to Draw a BLANK About – ISBLANK Zero?

8 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look at a common mistake made with zero(e)s.


A to Z of Excel Functions: The IMSECH Function

7 December 2020

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


Charts and Dashboards: Rolling Charts

4 December 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, we consider rolling charts, whatever they may be...


Power BI Blog: Managing Slicers

3 December 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at how to manage slicers in a multi-paged report.


Power Query: All Dates Must Change

2 December 2020

Welcome to our Power Query blog. This week, I look at how to dynamically set the Data Type on all my datetime columns to date.


Power Pivot Principles: Problems with 1 Month Ago – DATEADD vs. PREVIOUSMONTH

1 December 2020

Welcome back to the Power Pivot Principles blog. This week, we take a look back at, er, looking back and an associated classic gotcha.


Monday Morning Mulling: November 2020 Challenge

30 November 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


Final Friday Fix: November 2020 Challenge

27 November 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”.


Power BI Blog: Extending Report Page Size

26 November 2020

Welcome back to this week’s edition of the Power BI blog series. This week, we look at customising your report page size.


Newsletter