Measure Summary
This reference lists the DAX measures included in the prepared QQube Job Cost Details examples for Power BI and Excel Power Pivot. The measures support estimates, actual income and cost, commitments, time tracking, payroll, vehicle mileage, receivables, payables, and job-profitability analysis.
Data Model Job Cost Details | Reference Type DAX measure reference |
Visible Measures 399 | Display Folders 11 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
Base-measure visibility varies by data model.
The three visible base-measure folders are included because they support Job Cost Details, Time Tracking, and Vehicle Mileage calculations in this model.
DAX formulas and methodology
For the calculation methods and supporting patterns used in QQube, see DAX Methods Used in PowerPivot and Power BI.
Measure Folders
The measures are grouped below by the same display folders used in Power BI and Excel Power Pivot.
- .Base Job Cost Measures (71 measures)
- .Base Time Tracking Measures (18 measures)
- .Base Vehicle and Mileage Measures (17 measures)
- Calendar Pattern Job Cost Measures (88 measures)
- Calendar Pattern Mileage Measures (18 measures)
- Calendar Pattern Time Tracking Measures (28 measures)
- Job Cost Measures (87 measures)
- Payroll Hours Measures (10 measures)
- Purchase Order Measures (42 measures)
- Time Tracking Measures (10 measures)
- Vehicle Mileage Measures (10 measures)
.Base Job Cost Measures
Base calculations for estimates, actual income and cost, open commitments, accounts receivable, accounts payable, credits, discounts, and related job-cost values.
| Measure Name |
|---|
| .Line Credit Memo Applied To Document |
| .Line Credit Unapplied Amount |
| .Line Credits Applied On Document |
| .Line Discounts Applied On Document |
| .Line Discounts Applied To Document |
| .Line Estimate Cost Amount |
| .Line Estimate Cost Amount (Foreign) |
| .Line Estimate Cost Labor Amount |
| .Line Estimate Cost Materials Amount |
| .Line Estimate Income Amount |
| .Line Estimate Income Amount (Foreign) |
| .Line Estimate Labor Hours Quantity |
| .Line Estimate Markup Amount |
| .Line Estimate Markup Percent |
| .Line Estimate Quantity |
| .Line Exchange Rate |
| .Line Income Amount |
| .Line Income Open Amount |
| .Line Income Paid Amount |
| .Line Income Paid Amount (+Sign) |
| .Line Income Quantity |
| .Line Income Theoretical [Item Rate] Rate |
| .Line Income Theoretical [Item Rate] Value |
| .Line Income Theoretical [Item Rate] Value (Billed) |
| .Line Income Theoretical [Item Rate] Value (Unbilled) |
| .Line Income Theoretical [Job Rate] Rate |
| .Line Income Theoretical [Job Rate] Value |
| .Line Income Theoretical [Job Rate] Value (Billed) |
| .Line Income Theoretical [Job Rate] Value (Unbilled) |
| .Line Income Theoretical [Worker Rate] Rate |
| .Line Income Theoretical [Worker Rate] Value |
| .Line Income Theoretical [Worker Rate] Value (Billed) |
| .Line Income Theoretical [Worker Rate] Value (Unbilled) |
| .Line Job Cost Amount |
| .Line Job Cost Amount (Billable) |
| .Line Job Cost Amount (Billed) |
| .Line Job Cost Amount (No Billable Status) |
| .Line Job Cost Amount (Unbilled) |
| .Line Job Cost Labor Amount |
| .Line Job Cost Labor Amount (Billable) |
| .Line Job Cost Labor Amount (Billed) |
| .Line Job Cost Labor Amount (Unbilled) |
| .Line Job Cost Materials Amount |
| .Line Job Cost Materials Amount (Billable) |
| .Line Job Cost Materials Amount (Billed) |
| .Line Job Cost Materials Amount (Unbilled) |
| .Line Job Cost Open Amount |
| .Line Job Cost Other Amount |
| .Line Job Cost Other Amount (Billable) |
| .Line Job Cost Other Amount (Billed) |
| .Line Job Cost Other Amount (Unbilled) |
| .Line Job Cost Paid Amount |
| .Line Job Cost Paid Amount (Billable) |
| .Line Job Cost Paid Amount (Billed) |
| .Line Job Cost Paid Amount (Unbilled) |
| .Line Job Cost Quantity |
| .Line Job Cost Quantity (Billable) |
| .Line Job Cost Quantity (Billed) |
| .Line Job Cost Quantity (Unbilled) |
| .Line Payments Applied On Document |
| .Line Payments Applied To Document |
| .Line Payroll Hours Quantity |
| .Line Purchase Order Open Amount |
| .Line Purchase Order Open Quantity |
| .Line Purchase Order Original Amount |
| .Line Purchase Order Original Quantity |
| .Line Purchase Order Received Amount |
| .Line Purchase Order Received Quantity |
| .Line Rate |
| .Line Rate (Foreign) |
| .Line Rate Percent |
.Base Time Tracking Measures
Base time-tracking quantities, rates, and billable values used in Job Cost Details analysis.
| Measure Name |
|---|
| .Line Time Tracking Billing [item Rate] Value (Billable) |
| .Line Time Tracking Billing [item Rate] Value (Billed) |
| .Line Time Tracking Billing [item Rate] Value (Unbilled) |
| .Line Time Tracking Billing [Job Rate] Value (Billable) |
| .Line Time Tracking Billing [Job Rate] Value (Billed) |
| .Line Time Tracking Billing [Job Rate] Value (Unbilled) |
| .Line Time Tracking Billing [Worker Rate] Value (Billable) |
| .Line Time Tracking Billing [Worker Rate] Value (Billed) |
| .Line Time Tracking Billing [Worker Rate] Value (Not Billable) |
| .Line Time Tracking Billing [Worker Rate] Value (Unbilled) |
| .Line Time Tracking Hours (Any Status) |
| .Line Time Tracking Hours (Billable) |
| .Line Time Tracking Hours (Billed) |
| .Line Time Tracking Hours (Not Billable) |
| .Line Time Tracking Hours (Unbilled) |
| .Line Time Tracking Service Rate [Customer:Job Price Level] |
| .Line Time Tracking Service Rate [item Sales Price] |
| .Line Time Tracking Service Rate [Worker Billing Rate] |
.Base Vehicle and Mileage Measures
Base vehicle-mileage quantities, rates, and values used in Job Cost Details analysis.
| Measure Name |
|---|
| .Line Vehicle Mileage Billable Rate |
| .Line Vehicle Mileage Billing Value (Any Status) |
| .Line Vehicle Mileage Billing Value (Billable) |
| .Line Vehicle Mileage Billing Value (Billed) |
| .Line Vehicle Mileage Billing Value (Not Billable) |
| .Line Vehicle Mileage Billing Value (Unbilled) |
| .Line Vehicle Miles Quantity (Any Status) |
| .Line Vehicle Miles Quantity (Billable) |
| .Line Vehicle Miles Quantity (Billed) |
| .Line Vehicle Miles Quantity (Not Billable) |
| .Line Vehicle Miles Quantity (Unbilled) |
| .Line Vehicle Standard IRS Mileage Rate |
| .Line Vehicle Standard IRS Mileage Value (Any Status) |
| .Line Vehicle Standard IRS Mileage Value (Billable) |
| .Line Vehicle Standard IRS Mileage Value (Billed) |
| .Line Vehicle Standard IRS Mileage Value (Not Billable) |
| .Line Vehicle Standard IRS Mileage Value (Unbilled) |
Calendar Pattern Job Cost Measures
Cumulative and comparative job-cost measures organized by reporting periods.
| Measure Name |
|---|
| Credit Totals - Cumulative by Month |
| Credit Totals - Cumulative by Week |
| Credits Applied On Document - Cumulative by Month |
| Credits Applied On Document - Cumulative by Week |
| Credits Applied To Document - Cumulative by Month |
| Credits Applied To Document - Cumulative by Week |
| Discount Totals - Cumulative by Month |
| Discount Totals - Cumulative by Week |
| Discounts Applied On Document - Cumulative by Month |
| Discounts Applied On Document - Cumulative by Week |
| Discounts Applied To Document - Cumulative by Month |
| Discounts Applied To Document - Cumulative by Week |
| Income Amount - Cumulative by Month |
| Income Amount - Cumulative by Week |
| Income Quantity - Cumulative by Month |
| Income Quantity - Cumulative by Week |
| Job Cost Amount (Billable) - % to Total Cost Amount by Month |
| Job Cost Amount (Billable) - % to Total Cost Amount by Week |
| Job Cost Amount (Billable) - Cumulative by Month |
| Job Cost Amount (Billable) - Cumulative by Week |
| Job Cost Amount (Billed) - % to Billable by Month |
| Job Cost Amount (Billed) - % to Billable by Week |
| Job Cost Amount (Billed) - Cumulative by Month |
| Job Cost Amount (Billed) - Cumulative by Week |
| Job Cost Amount (No Billable Status) - Cumulative by Month |
| Job Cost Amount (No Billable Status) - Cumulative by Week |
| Job Cost Amount (Total) - Cumulative by Month |
| Job Cost Amount (Total) - Cumulative by Week |
| Job Cost Amount (Unbilled) - Cumulative by Month |
| Job Cost Amount (Unbilled) - Cumulative by Week |
| Job Cost Labor Amount (Billable) - % to Total Labor Cost by Month |
| Job Cost Labor Amount (Billable) - % to Total Labor Cost by Week |
| Job Cost Labor Amount (Billable) - Cumulative by Month |
| Job Cost Labor Amount (Billable) - Cumulative by Week |
| Job Cost Labor Amount (Billed) - % to Billable by Month |
| Job Cost Labor Amount (Billed) - % to Billable by Week |
| Job Cost Labor Amount (Billed) - Cumulative by Month |
| Job Cost Labor Amount (Billed) - Cumulative by Week |
| Job Cost Labor Amount (Total) - Cumulative by Month |
| Job Cost Labor Amount (Total) - Cumulative by Week |
| Job Cost Labor Amount (Unbilled) - Cumulative by Month |
| Job Cost Labor Amount (Unbilled) - Cumulative by Week |
| Job Cost Materials Amount (Billable) - % to Total Materials Cost by Month |
| Job Cost Materials Amount (Billable) - % to Total Materials Cost by Week |
| Job Cost Materials Amount (Billable) - Cumulative by Month |
| Job Cost Materials Amount (Billable) - Cumulative by Week |
| Job Cost Materials Amount (Billed) - % Billable by Month |
| Job Cost Materials Amount (Billed) - % Billable by Week |
| Job Cost Materials Amount (Billed) - Cumulative by Month |
| Job Cost Materials Amount (Billed) - Cumulative by Week |
| Job Cost Materials Amount (Total) - Cumulative by Month |
| Job Cost Materials Amount (Total) - Cumulative by Week |
| Job Cost Materials Amount (Unbilled) - Cumulative by Month |
| Job Cost Materials Amount (Unbilled) - Cumulative by Week |
| Job Cost Other Amount (Billable) - % to Total Other Cost by Month |
| Job Cost Other Amount (Billable) - % to Total Other Cost by Week |
| Job Cost Other Amount (Billable) - Cumulative by Month |
| Job Cost Other Amount (Billable) - Cumulative by Week |
| Job Cost Other Amount (Billed) - % to Billable by Month |
| Job Cost Other Amount (Billed) - % to Billable by Week |
| Job Cost Other Amount (Billed) - Cumulative by Month |
| Job Cost Other Amount (Billed) - Cumulative by Week |
| Job Cost Other Amount (Total) - Cumulative by Month |
| Job Cost Other Amount (Total) - Cumulative by Week |
| Job Cost Other Amount (Unbilled) - Cumulative by Month |
| Job Cost Other Amount (Unbilled) - Cumulative by Week |
| Job Cost Quantity (Billable) - Cumulative by Month |
| Job Cost Quantity (Billable) - Cumulative by Week |
| Job Cost Quantity (Billed) - Cumulative by Month |
| Job Cost Quantity (Billed) - Cumulative by Week |
| Job Cost Quantity (Total) - Cumulative by Month |
| Job Cost Quantity (Total) - Cumulative by Week |
| Job Cost Quantity (Unbilled) - Cumulative by Month |
| Job Cost Quantity (Unbilled) - Cumulative by Week |
| Payment Totals - Cumulative by Month |
| Payment Totals - Cumulative by Week |
| Payments Applied On Document - Cumulative by Month |
| Payments Applied On Document - Cumulative by Week |
| Payments Applied To Document - Cumulative by Month |
| Payments Applied To Document - Cumulative by Week |
| PO Open Amount - Cumulative by Month |
| PO Open Amount - Cumulative by Week |
| PO Open Quantity - Cumulative by Month |
| PO Open Quantity - Cumulative by Week |
| PO Received Amount - Cumulative by Month |
| PO Received Amount - Cumulative by Week |
| PO Received Quantity - Cumulative by Month |
| PO Received Quantity - Cumulative by Week |
Calendar Pattern Mileage Measures
Vehicle-mileage measures organized by job and reporting periods.
| Measure Name |
|---|
| Vehicle Miles (Billable) - % to Total by Month |
| Vehicle Miles (Billable) - % to Total by Week |
| Vehicle Miles (Billable) - Cumulative by Job |
| Vehicle Miles (Billable) - Cumulative by Month |
| Vehicle Miles (Billable) - Cumulative by Week |
| Vehicle Miles (Billable) Billing Rate - Average by Month |
| Vehicle Miles (Billable) Billing Rate - Average by Week |
| Vehicle Miles (Billable) Billing Value - Cumulative by Month |
| Vehicle Miles (Billable) Billing Value - Cumulative by Week |
| Vehicle Miles (Billed) - % to Billable by Month |
| Vehicle Miles (Billed) - % to Billable by Week |
| Vehicle Miles (Billed) - Cumulative by Month |
| Vehicle Miles (Billed) - Cumulative by Week |
| Vehicle Miles (Total) - Cumulative by Job |
| Vehicle Miles (Total) - Cumulative by Month |
| Vehicle Miles (Total) - Cumulative by Week |
| Vehicle Miles (Unbilled) - Cumulative by Month |
| Vehicle Miles (Unbilled) - Cumulative by Week |
Calendar Pattern Time Tracking Measures
Time-tracking measures organized by job and reporting periods.
| Measure Name |
|---|
| Time Tracking Hours (Billable) - % to Total by Month |
| Time Tracking Hours (Billable) - % to Total by Week |
| Time Tracking Hours (Billable) - Cumulative by Job |
| Time Tracking Hours (Billable) - Cumulative by Month |
| Time Tracking Hours (Billable) - Cumulative by Week |
| Time Tracking Hours (Billable) Billing Rate [Item] - Average by Month |
| Time Tracking Hours (Billable) Billing Rate [Item] - Average by Week |
| Time Tracking Hours (Billable) Billing Rate [Job] - Average by Month |
| Time Tracking Hours (Billable) Billing Rate [Job] - Average by Week |
| Time Tracking Hours (Billable) Billing Rate [Worker] - Average by Month |
| Time Tracking Hours (Billable) Billing Rate [Worker] - Average by Week |
| Time Tracking Hours (Billable) Billing Value [Item Rate] - Cumulative by Month |
| Time Tracking Hours (Billable) Billing Value [Item Rate] - Cumulative by Week |
| Time Tracking Hours (Billable) Billing Value [Job Rate] - Cumulative by Month |
| Time Tracking Hours (Billable) Billing Value [Job Rate] - Cumulative by Week |
| Time Tracking Hours (Billable) Billing Value [Worker Rate] - Cumulative by Month |
| Time Tracking Hours (Billable) Billing Value [Worker Rate] - Cumulative by Week |
| Time Tracking Hours (Billed) - % to Billable by Month |
| Time Tracking Hours (Billed) - % to Billable by Week |
| Time Tracking Hours (Billed) - Cumulative by Job |
| Time Tracking Hours (Billed) - Cumulative by Month |
| Time Tracking Hours (Billed) - Cumulative by Week |
| Time Tracking Hours (Total) - Cumulative by Job |
| Time Tracking Hours (Total) - Cumulative by Month |
| Time Tracking Hours (Total) - Cumulative by Week |
| Time Tracking Hours (Unbilled) - Cumulative by Job |
| Time Tracking Hours (Unbilled) - Cumulative by Month |
| Time Tracking Hours (Unbilled) - Cumulative by Week |
Job Cost Measures
Job profitability, completion, estimate-to-actual, committed-cost, margin, receivable, payable, and earned-revenue measures.
| Measure Name |
|---|
| Count of Jobs |
| Job - Committed % |
| Job - Committed Remaining |
| Job - Committed vs Actual |
| Job - Completion % |
| Job - Cost to Complete |
| Job - Earned Revenue to Date |
| Job - Estimate vs Actual |
| Job - Estimate vs Committed |
| Job - Estimated Profit |
| Job - Estimated Profit % |
| Job - Income to Date |
| Job - Over-Under Billing |
| Job - Profit % at End |
| Job - Profit at End |
| Job - Profit to Date |
| Job - Remaining Contract |
| Job Cost Amount - Current Month |
| Job Cost Amount - Current Month-to-Date |
| Job Cost Amount - Current Week |
| Job Cost Amount - Current Week-to-Date |
| Job Cost Amount - Last Month |
| Job Cost Amount - Last Month-to-Date |
| Job Cost Amount - Last Week |
| Job Cost Amount - Last Week-to-Date |
| Job Cost Amount - Today |
| Job Cost Amount - Yesterday |
| Job Cost Labor Amount - Current Month |
| Job Cost Labor Amount - Current Month-to-Date |
| Job Cost Labor Amount - Current Week |
| Job Cost Labor Amount - Current Week-to-Date |
| Job Cost Labor Amount - Last Month |
| Job Cost Labor Amount - Last Month-to-Date |
| Job Cost Labor Amount - Last Week |
| Job Cost Labor Amount - Last Week-to-Date |
| Job Cost Labor Amount - Today |
| Job Cost Labor Amount - Yesterday |
| Job Cost Materials Amount - Current Month |
| Job Cost Materials Amount - Current Month-to-Date |
| Job Cost Materials Amount - Current Week |
| Job Cost Materials Amount - Current Week-to-Date |
| Job Cost Materials Amount - Last Month |
| Job Cost Materials Amount - Last Month-to-Date |
| Job Cost Materials Amount - Last Week |
| Job Cost Materials Amount - Last Week-to-Date |
| Job Cost Materials Amount - Today |
| Job Cost Materials Amount - Yesterday |
| Job Cost Other Amount - Current Month |
| Job Cost Other Amount - Current Month-to-Date |
| Job Cost Other Amount - Current Week |
| Job Cost Other Amount - Current Week-to-Date |
| Job Cost Other Amount - Last Month |
| Job Cost Other Amount - Last Month-to-Date |
| Job Cost Other Amount - Last Week |
| Job Cost Other Amount - Last Week-to-Date |
| Job Cost Other Amount - Today |
| Job Cost Other Amount - Yesterday |
| Job Cost Quantity - Current Month |
| Job Cost Quantity - Current Month-to-Date |
| Job Cost Quantity - Current Week |
| Job Cost Quantity - Current Week-to-Date |
| Job Cost Quantity - Last Month |
| Job Cost Quantity - Last Month-to-Date |
| Job Cost Quantity - Last Week |
| Job Cost Quantity - Last Week-to-Date |
| Job Cost Quantity - Today |
| Job Cost Quantity - Yesterday |
| Job Income Amount - Current Month |
| Job Income Amount - Current Month-to-Date |
| Job Income Amount - Current Week |
| Job Income Amount - Current Week-to-Date |
| Job Income Amount - Last Month |
| Job Income Amount - Last Month-to-Date |
| Job Income Amount - Last Week |
| Job Income Amount - Last Week-to-Date |
| Job Income Amount - Today |
| Job Income Amount - Yesterday |
| Job Income Quantity - Current Month |
| Job Income Quantity - Current Month-to-Date |
| Job Income Quantity - Current Week |
| Job Income Quantity - Current Week-to-Date |
| Job Income Quantity - Last Month |
| Job Income Quantity - Last Month-to-Date |
| Job Income Quantity - Last Week |
| Job Income Quantity - Last Week-to-Date |
| Job Income Quantity - Today |
| Job Income Quantity - Yesterday |
Payroll Hours Measures
Payroll-hour measures for current and prior weeks and months.
| Measure Name |
|---|
| Payroll Hours - Current Month |
| Payroll Hours - Current Month-to-Date |
| Payroll Hours - Current Week |
| Payroll Hours - Current Week-to-Date |
| Payroll Hours - Last Month |
| Payroll Hours - Last Month-to-Date |
| Payroll Hours - Last Week |
| Payroll Hours - Last Week-to-Date |
| Payroll Hours - Today |
| Payroll Hours - Yesterday |
Purchase Order Measures
Open Purchase Order quantities and amounts for current and upcoming expected periods.
| Measure Name |
|---|
| PO Open Amount - Expected Current Month |
| PO Open Amount - Expected Current Quarter |
| PO Open Amount - Expected Current Week |
| PO Open Amount - Expected Current Year |
| PO Open Amount - Expected Next Month |
| PO Open Amount - Expected Next Quarter |
| PO Open Amount - Expected Next Two Weeks |
| PO Open Amount - Expected Next Week |
| PO Open Amount - Expected Next Year |
| PO Open Amount - Expected Today |
| PO Open Amount - Expected Tomorrow |
| PO Open Quantity - Expected Current Month |
| PO Open Quantity - Expected Current Quarter |
| PO Open Quantity - Expected Current Week |
| PO Open Quantity - Expected Current Year |
| PO Open Quantity - Expected Next Month |
| PO Open Quantity - Expected Next Quarter |
| PO Open Quantity - Expected Next Two Weeks |
| PO Open Quantity - Expected Next Week |
| PO Open Quantity - Expected Next Year |
| PO Open Quantity - Expected Today |
| PO Open Quantity - Expected Tomorrow |
| PO Received Amount - Current Month |
| PO Received Amount - Current Month-to-Date |
| PO Received Amount - Current Week |
| PO Received Amount - Current Week-to-Date |
| PO Received Amount - Last Month |
| PO Received Amount - Last Month-to-Date |
| PO Received Amount - Last Week |
| PO Received Amount - Last Week-to-Date |
| PO Received Amount - Today |
| PO Received Amount - Yesterday |
| PO Received Quantity - Current Month |
| PO Received Quantity - Current Month-to-Date |
| PO Received Quantity - Current Week |
| PO Received Quantity - Current Week-to-Date |
| PO Received Quantity - Last Month |
| PO Received Quantity - Last Month-to-Date |
| PO Received Quantity - Last Week |
| PO Received Quantity - Last Week-to-Date |
| PO Received Quantity - Today |
| PO Received Quantity - Yesterday |
Time Tracking Measures
Time-tracking hours for current and prior weeks and months.
| Measure Name |
|---|
| Time Tracking Hours - Current Month |
| Time Tracking Hours - Current Month-to-Date |
| Time Tracking Hours - Current Week |
| Time Tracking Hours - Current Week-to-Date |
| Time Tracking Hours - Last Month |
| Time Tracking Hours - Last Month-to-Date |
| Time Tracking Hours - Last Week |
| Time Tracking Hours - Last Week-to-Date |
| Time Tracking Hours - Today |
| Time Tracking Hours - Yesterday |
Vehicle Mileage Measures
Vehicle-mileage measures for current and prior periods using Trip End Date.
| Measure Name |
|---|
| Vehicle Miles - Current Month [Trip End Date] |
| Vehicle Miles - Current Month-to-Date [Trip End Date] |
| Vehicle Miles - Current Week [Trip End Date] |
| Vehicle Miles - Current Week-to-Date [Trip End Date] |
| Vehicle Miles - Last Month [Trip End Date] |
| Vehicle Miles - Last Month-to-Date [Trip End Date] |
| Vehicle Miles - Last Week [Trip End Date] |
| Vehicle Miles - Last Week-to-Date [Trip End Date] |
| Vehicle Miles - Today [Trip End Date] |
| Vehicle Miles - Yesterday [Trip End Date] |
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