O'Reilly logo

PowerPivot for Business Intelligence Using Excel and SharePoint by Barry Ralston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

images

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required