Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


A to Z of Excel Functions: the INFO Function

8 March 2021

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


Charts and Dashboards Blog: Bullet Charts – Part 3

5 March 2021

Welcome back to this week’s Charts and Dashboards blog series. This week, we complete our take on Bullet Charts.


Power BI Blog: Different Coloured Columns in a Stacked Column Chart

4 March 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will expand on the last week’s blog, this time with different coloured stacked column charts.


Power Query: Emerging from a Muddle

3 March 2021

Welcome to our Power Query blog. This week, I look at a more efficient way of merging the data from last week, again when there is not a clear link between the tables


Newsletter