Update on Table Queries

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. Marco Russo

    Glad to know you liked the technique! :)

  2. Steven Rutt

    I know this is a 2013 feature, but are there any 2010 workarounds?

    1. Scott Senkeresty

      Steven, I think your best bet would be to try http://daxstudio.codeplex.com/ — 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. Steven Rutt

        Thanks Scott!

  3. Dennis Sevilla

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

    1. Scott Senkeresty

      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 Comment or Question