Please note javascript is required for full website functionality.

Blog

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.


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.


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.


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 stage: you’re playing for bragging rights only!


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.


Power Query: Unique and Distinct

25 March 2020

Welcome to our Power Query blog. This week, I look at how to find the unique or distinct values in a list of data.


Power Pivot Principles: Using SELECTCOLUMNS to Create Calendar Table

24 March 2020

Welcome back to the Power Pivot Principles blog. This week, we are going to learn a new way of using a DAX function to create a calendar table.


A to Z of Excel Functions: The HEX2BIN Function

23 March 2020

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


Charts and Dashboards: Stock Charts

20 March 2020

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


Power BI Blog: Power BI Report Builder – Part 2

19 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 create reporting tables in the Power BI Report Builder.


Newsletter