Please note javascript is required for full website functionality.
MVP

Blog

Blog

Power Pivot Principles: Introducing the CALCULATETABLE Function

26 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the CALCULATETABLE Function.


Monday Morning Mulling: February 2019 Challenge

25 February 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


Final Friday Fix: February 2019 Challenge

22 February 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...


Power BI: Key Influencers Top Segments

21 February 2019

Welcome back to the Power BI blog. This time, we’re going to be talking about the other part of the Key Influencers visual: the Top Segments.


Power Query: File Away

20 February 2019

Welcome to our Power Query blog. This week I look at some of the M functionality for dealing with files.


Power Pivot Principles: Introducing the SUMX function

19 February 2019

Welcome back to our Power Pivot blog. Today, we discuss the SUMX function.


A to Z of Excel Functions: the EXPON.DIST Function

18 February 2019

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


VBA Blog: Selecting Case By Case

15 February 2019

This month, we’re talking about the Select Case statement in VBA. We had a question from a client that we thought we’d take the opportunity to answer here.


Power BI: Key Influencers

14 February 2019

This week in Power BI, we’re going to look at a brand new feature that’s just been released, called “Key Influencers”.


Power Query: Zoned Out

13 February 2019

Welcome to our Power Query blog. Last week’s blog looked at solving a particular problem by using DateTime.AddZone(). This week, I look at some of the M functionality for dealing with time zones.


Newsletter