Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Introducing the Function FIRSTNONBLANK

7 April 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new DAX function, FIRSTNONBLANK.


A to Z of Excel Functions: the HEX2OCT Function

6 April 2020

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


Charts and Dashboards Blog: Box and Whisker Charts

3 April 2020

Welcome back to this week’s Charts and Dashboards blog series. This week, let’s look at Box and Whisker Chart.


Power BI Blog: Power BI Report Builder – Part 4 (Creating Charts)

2 April 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at how to create charts in the Power BI Report Builder.


Power Query: Row by Row

1 April 2020

Welcome to our Power Query blog. This week, I look at how to add a table of data to an existing query.


Power Pivot Principles: Using USERELATIONSHIP to Activate an Inactive Relationship

31 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a method of creating a virtual relationship in Power Pivot.


A to Z of Excel Functions: the HEX2DEC Function

30 March 2020

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


Monday Morning Mulling: March 2019 Challenge

30 March 2020

On the final Friday of each month, we set an Excel 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: March 2020 Challenge

27 March 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 / Power BI fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this...


Power BI Blog: Power BI Report Builder – Part 3 (Editing Print Layouts)

26 March 2020

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau takes a look at how to edit the print layout of tables in the Power BI Report Builder.


Newsletter