Calculated Columns

Using the data from the BTS site, you can create a calculated column using DAX. To begin, download the data files from the BTS site at the following URL:

Figure 4-2 shows the download page.


Figure 4-2. BTS download site

From the BTS download site, ensure you choose the Prezipped option, and download the file to your development computer. Uncompressing the file will result in a file in the name form On_Time_On_Time_Performance_YYYY_MM.csv, where YYYY is the year of the data and MM is the month number. Import this file into PowerPivot for ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint 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.