Please note javascript is required for full website functionality.

Blog

Power Query: Conditional Column Splitting

30 January 2019

Welcome to our Power Query blog. This week, I look at an example where one column contains both header and detail data.


Power Pivot Principles: Variables and Disconnected Tables in Power BI

29 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use a combination of disconnected tables and variables to produce unique slicers in Power BI.


Challenges: Monday Morning Mulling: January 2019 Challenge

28 January 2019

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

25 January 2019

On the final Friday of each month, we’re going to set an Excel challenge for you to puzzle over so that you can get your “Excel 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: Microsoft Teams

24 January 2019

This week, we’re going to divert a little bit away from Power BI directly, and talk about how it can integrate into Microsoft Teams. This is the central part of what Tim’s presentation in Singapore last week was all about. We’ll spread this over the next few weeks. This first week, we’re just going to introduce what Microsoft Teams is, and how it can interface with Power BI.


Power Query: Select a Number

23 January 2019

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.


Power Pivot Principles: Variables in DAX

22 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to use variables in DAX.


A to Z of Excel Functions: The EVEN Function

21 January 2019

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


A to Z of Excel Functions: The EUROCONVERT Function

18 January 2019

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


Power BI Blog: Microsoft Ignite | The Tour Singapore

17 January 2019

This week, there are no new tips and tricks, but that’s because we’re presenting at Microsoft Ignite – The Tour over in Singapore!


Newsletter