Archive - Blog Posts on Performance

When to Use SUM() vs SUMX() - Level: Beginners/Intermediate (Updated Oct 2018). This is a further (third) update/edit to an article I first wrote 3 years back and then updated a year back.  When I update my articles I simply change the original post with the latest data – that way only the current/latest version is available preventing people stumbling on old […] Read More
Power Pivot Crashes? – An Update - Level: Beginners Today Avi Singh and I met with Howie Dickerman from Microsoft to discuss the Power Pivot for Excel Add-In.  You can read the background to this meeting at my blog post last month.  Howie is the Program Manager assigned to Power Pivot for Excel and has a wealth of experience with Excel and […] Read More