skip to Main Content

image

Buy and Download from MrExcel.com right now

If you’re ready to get started, go here and buy your eCopy today:

Buy and Download the eBook on MrExcel.com

(Indiegogo pre-orders of the eBook will also be emailing out today as well).

Physical books off to the printer!

<Yawns, stretches, rubs eyes>  Well folks it’s 100% done.  An intense final week of editing last week, and into the weekend, but as of 7 am Monday morning, the finished files were in the possession of Hess Print Solutions in Brimfield OH.  Now it’s merely a matter of them juggling their entire work queue in order to accommodate this milestone work.  (Step aside, Highlights for Children, the future of the human species hangs in the balance.)

Wait, Just NOW Done?  Yeah, we added a lot more Smile

Yeah, well, the crowdfunding campaign went so well, we decided we had to make the book even better.  The community helped us, and we wanted to make absolutely sure we were sufficiently returning the favor.  When the dust settled, the 2nd edition clocked in at a full 70 pages longer than the original, and includes such brand-new or completely rewritten chapters as:

2 – Power Pivot and the Power BI Family: Making Sense of the Various Versions
20 – Power Query to the Rescue
21 – Power BI Desktop
22 – “Complicated” Relationships
23 – Row and Filter Context Demystified
24 – CALCULATE and FILTER – More Nuances
26 – Advanced Calculated Columns
27 – New DAX Functions – and Variables!
28 – YouTube for Data (PowerBI.com and other Servers)
A2 – Cube Formulas – The End of GETPIVOTDATA()

All Three Versions of Excel Plus Power BI Desktop

Lots of coverage of the multiple Excel versions this time around, rather than a sole focus on Power Pivot 2010 like first edition.

All Existing Topics Clarified and Brought Up to Date

The vast majority of pre-existing pages of the book have been given clarified and updated as well.  The state of the art has advanced, both in tech as well as our ability to explain and teach, and we refreshed the “old” content accordingly.

Wait, You Changed the Title??

Yep, as we expanded the book to cover more than just Power Pivot, and more than just DAX, well, it didn’t seem right to keep the old name (DAX Formulas for Power Pivot).  Ah, DFPP, we will miss your acronym but not your full title.

Technically, a change of title means a new ISBN and this is technically not a second edition, but instead a brand new book.  Whatever.  It’s the same style you’re used to.  Trust us, it feels like a 2nd edition.  I’m even more proud of this one than the first one.  It just feels cleaner, more refined, more polished.

Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 34 Comments
  1. Awesome stuff!! Super psyched – can’t wait for the Indiegogo link!! Oh and I believe a ‘well done’ ‘in order!! This was a tough one, especially with Microsoft releasing updates while you are writing the book, so hats off to you and Avi. May the force be with you!!

  2. Phew! Just sent the email blast to all eBook recipients. It’s Nov 17th 11:45PM PST where I am, so we made it under the mark! You should have it in your inbox with links to download: PDF, ePUB or MOBI versions. Rest of your orders (Printed Books, T-Shirts etc.) are still expected to ship around early-mid December. You can always check the IndieGoGo page for the latest.

    1. I had the same 404 issue, but only after I hit the download link. The book opened in my browser and when I wanted to download it to my computer after 30 minutes, the 404 error came up. I was so close!

  3. Congratulations to you all! Can’t wait to get stuck in. Thanks for providing such an enjoyable and super useful platform – PowerPivotPro. Your commentary help me understand and put into context the transformation that Microsoft is undergoing. It’s cool that you can give an insight into what is happening behind the scenes in the Big Green too. Thanks for taking the plunge 🙂

  4. Great! Will there be an updated version of the three e-book bundle that included the 1st edition?
    I had that on my work wish list but obviously want the new version of your book now.

  5. I downloaded the PDF version and am looking forward to reading it. In my initial perusal, I noticed that there are about two dozen bookmarks that say “_GoBack”. There are some other bookmarks, at the beginning, that appear to duplicated later in a more finished style, for example “Preface/Forward/Intro” versus “Foreword and Forward” and “Introduction – Our Two Goals for this Book”

    My question is this – are all of the bookmarks, through the last “_GoBack” one Draft bookmarks that should be deleted?

  6. I want to say I am reading this at work and it is great so far. I attended your class and have both of the previous books and this is definitely an upgrade. I will be helping my team learn Powerpivot in the coming weeks and this book has a very natural feel that I will try to replicate.

    There is one small thing that may have already been addressed, but I was reading and on page 62 > Example 2: Growth Since Inception. I see the concept of Customer growth since a base year, it looks like you need a divide in the measure because the correlating pivot shows growth since 2001 as a %.

    Customer Growth Since 2001 :=
    DIVIDE ( [Active Customers] – [2001 Customers], [2001 Customers] )

    instead of

    Customer Growth Since 2001 :=
    [Active Customers] – [2001 Customers]

  7. Minor typo report, Pg 133 in the grey highlighted text on dateadd says “qtr 4” has being skipped. Should it be “qtr 3” instead?

  8. Avi/Rob, Chapter 23 is hands down the best explanation and example of the different contexts. Thanks for displaying this in such a clear way!

  9. Could you check the top of page 279 where it summarizes EXCEPT & INTERSECT? EXCEPT: “Returns the rows of the left-side table that appear on the right-side table”? Are the definitions for Except and Intersect switched?

  10. Hi Rob, our company library wants to buy the eBook. We are thinking of (a) downloading the ePub directly onto the requesting client’s device, (b) thereafer also load it onto our Gobii eReader device and lend this device to other interested individuals in the same office. Would this be allowable in terms of copyright? Putting it on a local network would obviously be an infringement of copyright. (The Gobii is compatible with both PDF and ePub, by the way).

      1. First shalt thou take out the Holy Pin, then shalt thou count to three, no more, no less. Three shall be the number thou shalt count, and the number of the counting shall be three. Four shalt thou not count, neither count thou two, excepting that thou then proceed to three. Five is right out. Once the number three, being the third number, be reached, then lobbest thou thy Holy Hand Grenade of Antioch towards thy foe, who being naughty in My sight, shall snuff it

  11. Hi,
    I purchased the ebook, but I can’t find a link to the dataset used in the examples. Can you please assist?
    Thanks!
    Eran

Leave a Comment or Question