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:
- I saw page after page that looked incredibly similar to my blog post… making me feel like a complete imposter.
- 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.