Please note javascript is required for full website functionality.
MVP

Blog

Blog

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.


Power Pivot Principles: Revisiting the SUM function

12 February 2019

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


A to Z of Excel Functions: the EXP Function

11 February 2019

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


VBA Blog: Select Case Flexibility

8 February 2019

This month, we’re talking about the Select Case statement. This week, we’re going to introduce tips to make the case statements more flexible.


Power BI: Publishing to Teams

7 February 2019

 

This is the final segment of our Teams project – how do we get our data from Power BI back into Teams?


Newsletter