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
YYYY is the year of the data and MM is the month number. Import this file into PowerPivot for ...