Chapter 12A Few Ideas: PowerPivot and DAX Solutions
The real world is the real world. Software, and books about software, can only give you “out-of-the-box” solutions. Real-world solutions require a bit more work. This chapter presents a few ideas for moving beyond “out-of-the-box” answers. It is all about implementing PowerPivot and DAX to deal with common business problems. The three appendixes that follow this chapter have a narrower focus, of how to write SQL, MDX, and DMX queries for assembling data in your PowerPivot model. In contrast, this chapter is more concerned with using DAX and the PowerPivot GUI to provide solutions, once you already have the data in place. That said, there is a little on importing data to address the problem of ...
Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
