Measure Summary
This reference lists the DAX measures included in the prepared QQube Time Tracking examples for Power BI and Excel Power Pivot. The measures support total, billable, billed, unbilled, and non-billable time analysis.
Data Model Time Tracking | Reference Type DAX measure reference |
Visible Measures 149 | Display Folders 6 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
Power BI company-filter measures
The two measures without a display folder support the Job and Source Name bridge tables used in Power BI. They limit each slicer to values associated with the selected company. Excel Power Pivot handles this filtering automatically.
DAX formulas and methodology
For the calculation methods and supporting patterns used in QQube, see DAX Methods Used in PowerPivot and Power BI.
Measure Sections
The measures are grouped below according to their placement in Power BI and Excel Power Pivot.
- Measures Without a Display Folder (2 measures)
- .Base Measures (17 measures)
- Calendar Pattern Measures (49 measures)
- Hours Billable Measures (44 measures)
- Hours Billed Measures (14 measures)
- Hours Not Billable Measures (7 measures)
- Hours Total Measures (16 measures)
Measures Without a Display Folder
Power BI support measures for the Job and Source Name bridge tables.
| Measure Name |
|---|
| Job Slicer: Company Filter |
| Source Name Slicer: Company Filter |
.Base Measures
Base calculations for total, billable, billed, unbilled, and non-billable hours, together with item, job, and worker rate values.
| Measure Name |
|---|
| .Billable Hours [Item Rate] Value |
| .Billable Hours [Item Rate] Value (Billed) |
| .Billable Hours [Item Rate] Value (Unbilled) |
| .Billable Hours [Job Rate] Value |
| .Billable Hours [Job Rate] Value (Billed) |
| .Billable Hours [Job Rate] Value (Unbilled) |
| .Billable Hours [Worker Rate] Value |
| .Billable Hours [Worker Rate] Value (Billed) |
| .Billable Hours [Worker Rate] Value (Unbilled) |
| .Rate [Customer:Job Price Level] for Billable Hours |
| .Rate [Item Sales Price] for Billable Hours |
| .Rate [Worker Billing Rate] for Billable Hours |
| .Total Billable Hours |
| .Total Billable Hours (Billed) |
| .Total Billable Hours (Unbilled) |
| .Total Hours Not Billable |
| .Total Hours of Any Status |
Calendar Pattern Measures
Cumulative, percentage, and value measures for time activity by week, month, and year.
| Measure Name |
|---|
| Billable Hours - % to Total by Month |
| Billable Hours - % to Total by Week |
| Billable Hours - % to Total by Year |
| Billable Hours - Cumulative (All) |
| Billable Hours - Cumulative by Month |
| Billable Hours - Cumulative by Week |
| Billable Hours - Cumulative by Year |
| Billable Hours [Item Rate] Value - Cumulative by Month |
| Billable Hours [Item Rate] Value - Cumulative by Week |
| Billable Hours [Item Rate] Value - Cumulative by Year |
| Billable Hours [Job Rate] Value - Cumulative by Month |
| Billable Hours [Job Rate] Value - Cumulative by Week |
| Billable Hours [Job Rate] Value - Cumulative by Year |
| Billable Hours [Worker Rate] Value - Cumulative by Month |
| Billable Hours [Worker Rate] Value - Cumulative by Week |
| Billable Hours [Worker Rate] Value - Cumulative by Year |
| Billable Hours Billing Rate [Item] - Average by Month |
| Billable Hours Billing Rate [Item] - Average by Week |
| Billable Hours Billing Rate [Item] - Average by Year |
| Billable Hours Billing Rate [Job] - Average by Month |
| Billable Hours Billing Rate [Job] - Average by Week |
| Billable Hours Billing Rate [Job] - Average by Year |
| Billable Hours Billing Rate [Worker] - Average by Month |
| Billable Hours Billing Rate [Worker] - Average by Week |
| Billable Hours Billing Rate [Worker] - Average by Year |
| Billed Hours - % to Billable by Month |
| Billed Hours - % to Billable by Week |
| Billed Hours - % to Billable by Year |
| Billed Hours - Cumulative (All) |
| Billed Hours - Cumulative by Month |
| Billed Hours - Cumulative by Week |
| Billed Hours - Cumulative by Year |
| Total Hours - Cumulative (All) |
| Total Hours - Cumulative by Month |
| Total Hours - Cumulative by Week |
| Total Hours - Cumulative by Year |
| Unbilled Hours - Cumulative (All) |
| Unbilled Hours - Cumulative by Month |
| Unbilled Hours - Cumulative by Week |
| Unbilled Hours - Cumulative by Year |
| Unbilled Hours [Item Rate] Value - Cumulative by Month |
| Unbilled Hours [Item Rate] Value - Cumulative by Week |
| Unbilled Hours [Item Rate] Value - Cumulative by Year |
| Unbilled Hours [Job Rate] Value - Cumulative by Month |
| Unbilled Hours [Job Rate] Value - Cumulative by Week |
| Unbilled Hours [Job Rate] Value - Cumulative by Year |
| Unbilled Hours [Worker Rate] Value - Cumulative by Month |
| Unbilled Hours [Worker Rate] Value - Cumulative by Week |
| Unbilled Hours [Worker Rate] Value - Cumulative by Year |
Hours Billable Measures
Current, prior-period, percentage, and comparative measures for billable hours.
| Measure Name |
|---|
| Billable Hours - % of Total Hours Current MTD |
| Billable Hours - % of Total Hours Current WTD |
| Billable Hours - % of Total Hours Current YTD |
| Billable Hours - % of Total Hours Current YTLM |
| Billable Hours - % of Total Hours Last Week |
| Billable Hours - % of Total Hours Today |
| Billable Hours - % of Total Hours Yesterday |
| Billable Hours - Current Month-to-Date |
| Billable Hours - Current Week-to-Date |
| Billable Hours - Current Year-to-Date |
| Billable Hours - Current Year-to-Last Month |
| Billable Hours - Last Week |
| Billable Hours - Today |
| Billable Hours - Yesterday |
| Billable Hours [Item] Value - Current Month-to-Date |
| Billable Hours [Item] Value - Current Year-to-Date |
| Billable Hours [Item] Value - Current Year-to-Last Month |
| Billable Hours [Item] Value - Last Week |
| Billable Hours [Item] Value - Today |
| Billable Hours [Item] Value - Yesterday |
| Billable Hours [Item] Value] - Current Week-to-Date |
| Billable Hours [Job] Value - Current Month-to-Date |
| Billable Hours [Job] Value - Current Week-to-Date |
| Billable Hours [Job] Value - Current Year-to-Date |
| Billable Hours [Job] Value - Current Year-to-Last Month |
| Billable Hours [Job] Value - Last Week |
| Billable Hours [Job] Value - Today |
| Billable Hours [Job] Value - Yesterday |
| Billable Hours [Worker] Value - Current Month-to-Date |
| Billable Hours [Worker] Value - Current Week-to-Date |
| Billable Hours [Worker] Value - Current Year-to-Date |
| Billable Hours [Worker] Value - Current Year-to-Last Month |
| Billable Hours [Worker] Value - Last Month |
| Billable Hours [Worker] Value - Last Month-to-Date |
| Billable Hours [Worker] Value - Last Week |
| Billable Hours [Worker] Value - Last Week-to-Date |
| Billable Hours [Worker] Value - Previous Year |
| Billable Hours [Worker] Value - Previous Year Last Month |
| Billable Hours [Worker] Value - Previous Year Month |
| Billable Hours [Worker] Value - Previous Year Month-to-Date |
| Billable Hours [Worker] Value - Previous Year-to-Date |
| Billable Hours [Worker] Value - Previous Year-to-Last Month |
| Billable Hours [Worker] Value - Today |
| Billable Hours [Worker] Value - Yesterday |
Hours Billed Measures
Current and prior-period measures for billed hours and billed percentages.
| Measure Name |
|---|
| Billed Hours - % of Billable Hours Current MTD |
| Billed Hours - % of Billable Hours Current WTD |
| Billed Hours - % of Billable Hours Current YTD |
| Billed Hours - % of Billable Hours Current YTLM |
| Billed Hours - % of Billable Hours Last Week |
| Billed Hours - % of Billable Hours Today |
| Billed Hours - % of Billable Hours Yesterday |
| Billed Hours - Current Month-to-Date |
| Billed Hours - Current Week-to-Date |
| Billed Hours - Current Year-to-Date |
| Billed Hours - Current Year-to-Last Month |
| Billed Hours - Last Week |
| Billed Hours - Today |
| Billed Hours - Yesterday |
Hours Not Billable Measures
Current and prior-period measures for non-billable hours.
| Measure Name |
|---|
| Not Billable Hours - Current Month-to-Date |
| Not Billable Hours - Current Week-to-Date |
| Not Billable Hours - Current Year-to-Date |
| Not Billable Hours - Current Year-to-Last Month |
| Not Billable Hours - Last Week |
| Not Billable Hours - Today |
| Not Billable Hours - Yesterday |
Hours Total Measures
Current and prior-period measures for total tracked hours.
| Measure Name |
|---|
| Total Hours - Current Month-to-Date |
| Total Hours - Current Week-to-Date |
| Total Hours - Current Year-to-Date |
| Total Hours - Current Year-to-Last Month |
| Total Hours - Last Month |
| Total Hours - Last Month-to-Date |
| Total Hours - Last Week |
| Total Hours - Last Week-to-Date |
| Total Hours - Previous Year |
| Total Hours - Previous Year Last Month |
| Total Hours - Previous Year Month |
| Total Hours - Previous Year Month-to-Date |
| Total Hours - Previous Year-to-Date |
| Total Hours - Previous Year-to-Last Month |
| Total Hours - Today |
| Total Hours - Yesterday |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article