-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
For certain organizations, such as consulting and professional services firms, there is no more important metric than utilization. Utilization is calculated as a percentage and is simply the amount of billable time divided by the total amount of time possible within a given period. Most often, the inputs to utilization calculations are hours.
To prepare for this calculation, download the Chapter8_Utilization.xlsx file from the GitHub repository for this book: https://github.com/gdeckler/DAX-For-Humans/tree/main/book
Import the Hours tab from Chapter8_Utilization.xlsx as a table named Hours and the Tasks tab as a table named Tasks. For Tasks, you may need to edit the query to ensure that the first row is used as headers.
Create a relationship between the Tasks table and Hours table based upon the TaskID columns. If you have a Dates table, you can also create a relationship between your Dates table and Hours table based upon the Date columns.
Create the following measure in...