O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required