Please note javascript is required for full website functionality.

Blog

Power Query: More Merging Matters

24 March 2021

Welcome to our Power Query blog. This week, I look at some ways to make merges more efficient.


A to Z of Excel Functions: The INTERCEPT Function

22 March 2021

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


Charts and Dashboards: Conditional Donut Chart – Part 2

19 March 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we will continue to build the “conditional donut chart”.


Power BI Blog: Ordered Legends

18 March 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at ordering the legend in visualisations.


Power Query: Merging Matters

17 March 2021

Welcome to our Power Query blog. This week, I look at solving a problem with a nested join and the M function Table.Buffer().


Power Pivot Principles: Credit Transactions

16 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll continue where we left off last week, revealing “the truth” about the different negative and positive values.


A to Z of Excel Functions: The INT Function

15 March 2021

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


Charts and Dashboards: Conditional Donut Chart – Part 1

12 March 2021

Welcome back to this week’s Charts and Dashboards blog series. Over the next few weeks, we will build a “conditional donut chart”.


Power BI Blog: Dealing with an Excessive Number of Categories

11 March 2021

Welcome back to this week’s edition of the Power BI blog series. This week, we will look at grouping categories when the number becomes excessive.


Power Query: Self Merging

10 March 2021

Welcome to our Power Query blog. This week, I look at a way to reorganise data in a table by merging with itself.


Newsletter