Please note javascript is required for full website functionality.
MVP

Blog

Blog

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: 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.


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 blog: ActiveWorkbook.Saved = True vs AutoSave

11 January 2019

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


Power BI: 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().


Newsletter