Please note javascript is required for full website functionality.
MVP

Blog

Blog

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 Blog: 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, Jonathan Liau 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 Blog: 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, Jonathan Liau 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.


Power Pivot Principles: Budget vs Actuals

9 March 2021

Welcome back to the Power Pivot Principles blog. This week, we’ll create a quarterly Budget vs Actuals table based on different Account aggregation.


Newsletter