Chapter 47 Power Pivot
Questions answered in this chapter:
How do I read data into Power Pivot?
How do I use Power Pivot to create a pivot table?
How can I use slicers with Power Pivot?
What are DAX functions and calculated columns?
How does the RELATED function work?
How does the CALCULATE function work, and what is a calculated measure?
Power Pivot is (or soon will be available) in all versions of Excel, from 2016 and newer. To add Power Pivot, click the File tab, select Options, and then select Add-Ins. At the bottom of the Add-Ins dialog box, in the Manage list, select COM Add-Ins, and then click Go. In the COM Add-Ins dialog box, check Microsoft Power Pivot For Excel, and then click OK. You will now see a Power Pivot tab on the ribbon. ...
Get Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition 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.
