Please note javascript is required for full website functionality.

Blog

Power BI Blog: Excel Summit South 2019

1 August 2019

Hello there! We thought we’d take a break from our regular tips and tricks and thought we’d let you know we’re presenting at the Excel Summit South 2019 in Sydney…


Power Query: Functioning Columns

31 July 2019

Welcome to our Power Query blog. Today, I create a function to add a column to a table.


Power Pivot Principles: Introducing the DATESINPERIOD Function

30 July 2019

Welcome back to our Power Pivot blog. Today, we show you how the DATESINPERIOD function works.


Challenges: Monday Morning Mulling: July 2019 Challenge

29 July 2019

On the final Friday of each month, we set a Power BI or 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.


Challenges: Final Friday Fix: July 2019 Challenge

26 July 2019

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’s no prizes at this stage, you’re playing for bragging rights only!


Power BI Blog: Floor Plan

25 July 2019

Welcome back to this week’s Power BI blog series. This week, we are as far removed from financial modelling as we’ll ever be: we’re going to create a floor plan.


Power Query: Combining Forces

24 July 2019

Welcome to our Power Query blog. Today, I look at a way to reduce overheads when combining numerous files.


Power Pivot Principles: Dynamic Ranking based on Selection Filters

23 July 2019

Welcome back to our Power Pivot blog. Today, we show you how to create a dynamic ranking measure that changes based on selection filters.


A to Z of Excel Functions: The FLOOR Function

22 July 2019

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


Power BI Blog: Mekko Chart (cont'd)

18 July 2019

Welcome back to this week’s Power BI blog series. This week, we continue with Mekko Chart.


Newsletter