skip to Main Content

Guest post by Scott Senkeresty

After completing this post on table queries, I celebrated by curling up with Microsoft Excel 2013: Building Data Models with PowerPivot.  It’s a great book by Marco Russo and Alberto Ferrari.  (I’ve read Rob’s book now multiple times, and I was even the tech editor on it, so it was time to step up and read the other leading book).

When I got to chapter 14 in the Italians’ book, two things happened:

  1. I saw page after page that looked incredibly similar to my blog post… making me feel like a complete imposter.
  2. I saw “the next level”.

The Italians don’t just bring data into a table via DAX.  They further manipulate the data (with standard techniques excel pros know and love), and then, link this newly created table back to their power pivot model for further analysis with DAX!  And it all responds to Refresh.   Totally.  Awesome.

This Post Has 6 Comments
    1. Steven, I think your best bet would be to try — though, it’s not going to allow the rich experience described in Marco & Alberto’s book, it will still let you “see the results of a DAX query”. I would love if somebody had a better workaround for 2010…

  1. Sorry but dumb question. Does this mean you can update a table and re pull it into a PowerPivot model without redoing everything?

    1. It’s always true that if you create a powerpivot table that is linked to a “normal” excel table it is “live”. New rows and columns added to the excel table with get reflected in the powerpivot table.

      Is that what you were asking?

Leave a Reply

Your email address will not be published. Required fields are marked *