Vehicle Mileage Data Model

Overview of the QuickBooks Vehicle Mileage Data Model

The Vehicle Mileage data model is a standalone option for calculating IRS mileage values, and monitoring vehicle use. It is also included in the Job Cost Details data model.  The Trip End Date is best calendar dimension to analyze across time periods.

Features

• Over 250 available fields
• 15 Measures including 8 not available in any QuickBooks report
• 153 Additional DAX measures for Power/Pivot and Power BI
• Vehicle Mileage Records

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Trip End Date Trip Start Date Job End Date Job Projected End Date Job Start Date More Info on Calendars
	Document Based Dimensions:  Document Attributes Line Attributes
	List Based Dimensions:  Class Company Customer Customer Rep Job Job Rep Service Item Vehicle
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI