Creating calculations

We now have a workable data model that contains all of the raw data we will need to report on utilization. Recall that, at the beginning of Chapter 4, Connecting to and Transforming Data, with the rollout of unlimited Paid Time Off (PTO), it is imperative that employee utilization be tracked closely.

Utilization in this context is a calculation that involves the ratio of billable time versus the total time (billable and non-billable). From experience, the organization knows that, in order to remain profitable, the target utilization must be 80%. Therefore, we must create this calculation.

Calculated columns

Calculated columns are additional columns that are created in data model tables through the use of the DAX formula language. Calculated columns are computed for each row in a table at the time of their creation, as well as during the refresh process. Hence, the data refresh process executes the queries defined in Power Query Editor. These queries create...