Database Reference
In-Depth Information
Figure 11.22
Adding a measure to the model.
2. In a similar fashion, add the following measures to the model:
MaxDelay:=Max([delay])
AveDelay:=AVERAGE([delay])
In addition to measures, you can add calculated columns to the model.
3. Click the cell under the Add Column header in the flight_dept table tab.
Enter the following formula to bucket the delays into ranges:
=IF([delay]<=15,"small",IF([delay]<=60,
"medium","large"))
4. Right-click the column header and rename it to
DelaySeverity
.
5. Repeat the process to determine the flight day of the week using the
following DAX formula:
=Format([flight_date],"DDD")
6. Rename the column to
DepartureDay
. Create another column called
DayOfWeek
using the following formula:
=WEEKDAY([flight_date])
7. Select the DepartureDay column and under the Home tab select Sort by
Column. Sort the column by the DayOfWeek column.
Now that the model has been created, you can create pivot tables to analyze
the data.
