Please note javascript is required for full website functionality.

Blog

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!


Power Query: A Join I Made Earlier

16 January 2019

Welcome to our Power Query blog. This week, I look at a neat way of linking tables with similar key data.


Power Pivot Principles: KEEPFILTERS to the Rescue

15 January 2019

Welcome back to our Power Pivot blog. Today, we discuss an alternate way to keep the CALCULATE function from misbehaving.


A to Z of Excel Functions: The ERROR.TYPE Function

14 January 2019

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


VBA Blogs: ActiveWorkbook.Saved = True vs AutoSave

11 January 2019

When you thought that AutoSave couldn’t get any worse…


Power BI Blog: Keyboard Shortcuts

10 January 2019

Something different this week. Just for those who like that sort of thing, here’s the current list of keyboard shortcuts as cited by Microsoft in various locations for Power BI Desktop.


Power Query: Skipping Lists

9 January 2019

Welcome to our Power Query blog. This week I look at M functions List.Skip() and List.Alternate().


Power Pivot Principles: When the CALCULATE Function Misbehaves.

8 January 2019

Welcome back to our Power Pivot blog. Today, we discuss how to stop the CALCULATE function from overwriting row filters.


A to Z of Excel Functions: The ERFC.PRECISE Function

7 January 2019

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


VBA Blogs: Going Through the Visual Basics – Part 18

4 January 2019

We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog marks the Event-ful end of this series…


Newsletter