In most cases, you won’t need EARLIER anymore. But for now, just know that we’ve got this exciting new capability coming to us. Variables DEFINITELY deserve their own post. (But now we can do it with variables in DAX) This Subtotal Calc Column Used to Require the Use of the EARLIER Function
Plus, we now gain the GOOD kind of consistency, where the same thing is given the same name in all environments.
Power map preview for excel 2013 mac software#
It was done in the name of Consistency, and we all know that a foolish consistency is the hobgoblin of software projects.Įxcel team, I salute you for reversing course. The 2013 name change, in other words, would scare you off from discovering Measures, the greatest thing ever. So why, in 2013, were they renamed “Calculated Fields?” That’s the name of the calculation feature in traditional pivots that literally has about 0.00000001 % of the power of Measures. Power Pivot measures are a life-changing capability. I’ve sent some EPIC email rants on this topic over the years. (“Calculated Fields” were/are the long-neglected, woefully underpowered feature of traditional pivots) The Most Amazing Formula Feature In the World is back to Having a Decent Name Speaking of Which… “MEASURES” are Back!!! Or at least, once we’re all using 2016 regularly.
Introduced in 2013 to compensate us for the loss of right click edit, that thing made me grumpy every time I used it. I can pretty safely say that I will never use the “Manage Measures” dialog box ever again. (Again, a 2010 Convenience that was ripped from us in 2013) In the Field List, You Can Now Right Click and Edit a Measure! Even Better: Right Click and Edit Measures in Field List! We welcome them back to our world with open arms. 2016 Puts them BackĪ bit cosmetic perhaps, but if you never used 2010 Power Pivot, you have NO IDEA how useful these are. It’s a monstrous win.Įach of these improvements warrants its own in-depth blog post, but for now, let’s just run through the list of things that catch my eye… Measure Icons and Search in the Field List! Unlike 2013, which offered us little noticeable benefit over 2010 Power Pivot, I can’t wait for 2016 to become mainstream. The next release of Excel (2016) brings MAJOR improvements to our world. ***UPDATE Oct 2015: The preview period is now closed, but this post will help you find a version of Office 2016 that includes Power Pivot. Just go grab the preview and slap it on a “spare” computer. Everything listed below is now also available to you to look at as well. I’m traditionally very slow to look at interim releases of software, but the Office 2016 public preview is out.
Seriously, I Want to Hug the Computer and Every Software Engineer in Redmond Tales from the Preview