Measure Summary
This reference lists the DAX measures included in the prepared QQube Vehicle Mileage examples for Power BI and Excel Power Pivot.
Data Model Vehicle Mileage | Reference Type DAX measure reference |
Visible Measures 122 | Display Folders 7 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
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.
- .Base Measures (17 measures)
- Calendar Pattern Measures (43 measures)
- Miles Billable Measures (21 measures)
- Miles Billed Measures (14 measures)
- Miles Not Billable Measures (7 measures)
- Miles Total Measures (16 measures)
- Miles Unbilled Measures (4 measures)
.Base Measures
Base calculations used by the customer-facing Vehicle Mileage measures.
| Measure Name |
|---|
| .Billable Miles Value |
| .Billable Miles Value (Billed) |
| .Billable Miles Value (Unbilled) |
| .IRS Mileage Rate (Any Status) |
| .IRS Mileage Value for Billable Miles |
| .IRS Mileage Value for Billable Miles (Billed) |
| .IRS Mileage Value for Billable Miles (Unbilled) |
| .IRS Mileage Value for Miles Not Billable |
| .IRS Mileage Value for Miles of Any Status |
| .Rate for Billable Miles |
| .Rate for Billable Miles (Billed) |
| .Rate for Billable Miles (Unbilled) |
| .Total Billable Miles |
| .Total Billable Miles (Billed) |
| .Total Billable Miles (Unbilled) |
| .Total Miles Not Billable |
| .Total Miles of Any Status |
Calendar Pattern Measures
Vehicle Mileage measures organized by date periods.
| Measure Name |
|---|
| Billable Miles - % to Total by Month |
| Billable Miles - % to Total by Quarter |
| Billable Miles - % to Total by Week |
| Billable Miles - % to Total by Year |
| Billable Miles - Cumulative (All) |
| Billable Miles - Cumulative by Month |
| Billable Miles - Cumulative by Quarter |
| Billable Miles - Cumulative by Week |
| Billable Miles - Cumulative by Year |
| Billable Miles Billing Rate - Average by Month |
| Billable Miles Billing Rate - Average by Quarter |
| Billable Miles Billing Rate - Average by Week |
| Billable Miles Billing Rate - Average by Year |
| Billable Miles Value - Cumulative by Month |
| Billable Miles Value - Cumulative by Quarter |
| Billable Miles Value - Cumulative by Week |
| Billable Miles Value - Cumulative by Year |
| Billed Miles - % to Billable by Month |
| Billed Miles - % to Billable by Quarter |
| Billed Miles - % to Billable by Week |
| Billed Miles - % to Billable by Year |
| Billed Miles - Cumulative (All) |
| Billed Miles - Cumulative by Month |
| Billed Miles - Cumulative by Quarter |
| Billed Miles - Cumulative by Week |
| Billed Miles - Cumulative by Year |
| Billed Miles Value - Cumulative by Month |
| Billed Miles Value - Cumulative by Quarter |
| Billed Miles Value - Cumulative by Week |
| Billed Miles Value - Cumulative by Year |
| IRS Mileage Value - Cumulative by Month |
| IRS Mileage Value - Cumulative by Quarter |
| IRS Mileage Value - Cumulative by Week |
| IRS Mileage Value - Cumulative by Year |
| Total Miles - Cumulative (All) |
| Total Miles - Cumulative by Month |
| Total Miles - Cumulative by Quarter |
| Total Miles - Cumulative by Week |
| Total Miles - Cumulative by Year |
| Unbilled Miles Value - Cumulative by Month |
| Unbilled Miles Value - Cumulative by Quarter |
| Unbilled Miles Value - Cumulative by Week |
| Unbilled Miles Value - Cumulative by Year |
Miles Billable Measures
Measures grouped under the same display folder used in Power BI and Excel Power Pivot.
| Measure Name |
|---|
| Billable Miles - % of Total Miles Current MTD |
| Billable Miles - % of Total Miles Current WTD |
| Billable Miles - % of Total Miles Current YTD |
| Billable Miles - % of Total Miles Current YTLM |
| Billable Miles - % of Total Miles Last Week |
| Billable Miles - % of Total Miles Today |
| Billable Miles - % of Total Miles Yesterday |
| Billable Miles - Current Month-to-Date |
| Billable Miles - Current Week-to-Date |
| Billable Miles - Current Year-to-Date |
| Billable Miles - Current Year-to-Last Month |
| Billable Miles - Last Week |
| Billable Miles - Today |
| Billable Miles - Yesterday |
| Billable Miles Value - Current Month-to-Date |
| Billable Miles Value - Current Week-to-Date |
| Billable Miles Value - Current Year-to-Date |
| Billable Miles Value - Current Year-to-Last Month |
| Billable Miles Value - Last Week |
| Billable Miles Value - Today |
| Billable Miles Value - Yesterday |
Miles Billed Measures
Measures grouped under the same display folder used in Power BI and Excel Power Pivot.
| Measure Name |
|---|
| Billed Miles - % of Billable Miles Current MTD |
| Billed Miles - % of Billable Miles Current WTD |
| Billed Miles - % of Billable Miles Current YTD |
| Billed Miles - % of Billable Miles Current YTLM |
| Billed Miles - % of Billable Miles Last Week |
| Billed Miles - % of Billable Miles Today |
| Billed Miles - % of Billable Miles Yesterday |
| Billed Miles - Current Month-to-Date |
| Billed Miles - Current Week-to-Date |
| Billed Miles - Current Year-to-Date |
| Billed Miles - Current Year-to-Last Month |
| Billed Miles - Last Week |
| Billed Miles - Today |
| Billed Miles - Yesterday |
Miles Not Billable Measures
Measures grouped under the same display folder used in Power BI and Excel Power Pivot.
| Measure Name |
|---|
| Not Billable Miles - Current Month-to-Date |
| Not Billable Miles - Current Week-to-Date |
| Not Billable Miles - Current Year-to-Date |
| Not Billable Miles - Current Year-to-Last Month |
| Not Billable Miles - Last Week |
| Not Billable Miles - Today |
| Not Billable Miles - Yesterday |
Miles Total Measures
Measures grouped under the same display folder used in Power BI and Excel Power Pivot.
| Measure Name |
|---|
| Total Miles - Current Month-to-Date |
| Total Miles - Current Week-to-Date |
| Total Miles - Current Year-to-Date |
| Total Miles - Current Year-to-Last Month |
| Total Miles - Last Month |
| Total Miles - Last Month-to-Date |
| Total Miles - Last Week |
| Total Miles - Last Week-to-Date |
| Total Miles - Previous Year |
| Total Miles - Previous Year Last Month |
| Total Miles - Previous Year Month |
| Total Miles - Previous Year Month-to-Date |
| Total Miles - Previous Year-to-Date |
| Total Miles - Previous Year-to-Last Month |
| Total Miles - Today |
| Total Miles - Yesterday |
Miles Unbilled Measures
Measures grouped under the same display folder used in Power BI and Excel Power Pivot.
| Measure Name |
|---|
| Unbilled Miles - Current Month-to-Date |
| Unbilled Miles - Current Week-to-Date |
| Unbilled Miles - Current Year-to-Date |
| Unbilled Miles - Current Year-to-Last Month |
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