Creating your first measure – where to go

Before we create our first measure, it would be a good idea to store all our measures in one table. This will make it easier to organize our measures and separate them from other fields in our data.

To create such a measures table, follow these steps:

1. Select an empty cell in your worksheet.
2. Copy the empty cell and click on the Manage button, as shown in the following screenshot:

Figure 5.2 – Creating a table for measures

3. This should open the Power Pivot window.
4. Click on Paste under the Home tab:

Figure 5.3 – The Paste dialog box in Power Pivot

This brings up the following Paste Preview dialog box:

Figure 5.4 – Naming your measures

You can now assign a new name to the table. In my case, I named it My Measures. Click OK to finish the process.

You should now find a new table pasted in your data...