LEADER 04368nam 2200553Ia 450 001 9910810319403321 005 20240313081227.0 010 $a1-61547-112-X 010 $a1-61547-212-6 035 $a(CKB)2550000001132871 035 $a(OCoLC)847588649 035 $a(CaPaEBR)ebrary10635796 035 $a(SSID)ssj0000812710 035 $a(PQKBManifestationID)11435974 035 $a(PQKBTitleCode)TC0000812710 035 $a(PQKBWorkID)10867604 035 $a(PQKB)10700041 035 $a(MiAaPQ)EBC1073006 035 $a(Au-PeEL)EBL1073006 035 $a(CaPaEBR)ebr10635796 035 $a(CaONFJC)MIL532580 035 $a(OCoLC)818851430 035 $a(EXLCZ)992550000001132871 100 $a20130103d2013 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDAX formulas for PowerPivot $ethe Excel pro's guide to mastering DAX /$fRob Collie 205 $a1st ed. 210 $aUniontown, OH $cHoly Macro! Books$dc2013 215 $a1 online resource (255 p.) 300 $aIncludes index. 311 $a1-61547-015-8 311 $a1-306-01329-1 327 $aIntro -- _GoBack -- Preface/Forward/Intro -- First Chapter -- Copyright page -- Index -- Acknowledgements -- Supporting Workbooks and Data Sets -- A Note on Hyperlinks -- Introduction -- 1- A Revolution Built on YOU -- 2- What Version of PowerPivot Should You Use? -- 3- Learning PowerPivot "The Excel Way" -- 4- Loading Data Into PowerPivot -- 5- Intro to Calculated Columns -- 6- Introduction to DAX Measures -- 7- The "Golden Rules" of DAX Measures -- 8- CALCULATE() - Your New Favorite Function -- 9- ALL() - The "Remove a Filter" Function -- 10- Thinking in Multiple Tables -- 11- "Intermission" - Taking Stock of Your New Powers -- 12- Disconnected Tables -- 13- Introducing the FILTER() Function, and Disconnected Tables Continued -- 14- Introduction to Time Intelligence -- 15- IF(), SWITCH(), BLANK(), and Other Conditional Fun -- 16- SUMX() and Other X ("Iterator") Functions -- 17- Multiple Data Tables -- 18- Time Intelligence with Custom Calendars: Advanced Use of FILTER() -- 19- Performance: How to keep things running fast. -- 20- Advanced Calculated Columns -- 21- The Final Transformation: One Click That Will Change Your Life Forever -- A1- Further Proof That the Game is Changing -- A2- So Much Power, So Little Space: Further Capabilities -- A3- Four Common Error Messages -- A4- People: The Most Powerful Feature of PowerPivot -- Index. 330 $aMicrosoft's Power Pivot is an add-on to Excel that enables you to produce new kinds of reports and analyses that were simply impossible before. This book is the first to tackle DAX formulas, the core capability of Power Pivot, from the perspective of the Excel audience. Written by a leading Power Pivot educator (and former leader on the Power Pivot and Excel teams at Microsoft), the book's concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. In this book you will learn how Power Pivot:  1) Gives you "portable" formulas that can be re-used across multiple different reports with a single click.2) Removes the need to ever write a VLOOKUP formula again.3) Allows you to add smart calculations to pivots, such as "Year over Year" and "Moving Averages" which auto-adjust as the pivot changes.4) Effortlessly merges disjointed sets of data into unified insight. As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft's "Power BI" system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence - a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career - and your organization's future - starts within these pages. 606 $aBusiness intelligence$xComputer programs 615 0$aBusiness intelligence$xComputer programs. 676 $a005.54 700 $aCollie$b Rob$01601478 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910810319403321 996 $aDAX formulas for PowerPivot$94035943 997 $aUNINA