␡
- Downloading and Installing PowerPivot
- Getting your Data into PowerPivot
- Linking an Excel Table to PowerPivot
- Importing Data into PowerPivot
- Adding DAX Calculations to the Grid
- Creating Pivot Tables from PowerPivot
- Defining a Relationship Between Worksheets
- Using Automatic Relationship Detection
- Using Explicit Relationships
- Using the RELATED Function in the PowerPivot Grid
- Adding Slicers to Drive All Pivot Elements
- Adding DAX Calculations to the PivotTable
- Entering a Measure
- Using the X Functions
- Using CountRows and Distinct
- PowerPivot Is a Home Run
Like this article? We recommend
Getting your Data into PowerPivot
Getting your Data into PowerPivot
There are many ways to get data into PowerPivot. If you have data that is already in Excel, you can simply copy the data (including one row of headings), go to the PowerPivot window, and paste the data into PowerPivot.
However, this creates a second copy of the data that will not reflect changes made in Excel, so you should consider creating a linked table instead.