Fixed Assets Data Model

Overview of the QuickBooks Fixed Assets Data Model

The Fixed Asset Data Model is dependent upon the information entered in the Item List in QuickBooks - and not the Fixed Asset 3rd party module within the application.

Features

• Over 95 available fields
• 7 Base QQube measures
• 29 DAX Measures for Power Pivot and Power BI

Output Examples

Schema

AVAILABLE FIELDS	DIMENSION DETAIL LINKS
	Dates and Calendar Dimensions: Asset Purchase Date Asset Sales Date Asset Warranty Expiration Date More Info on Calendars
	Document Based Dimensions:  NONE
	List Based Dimensions:  Account (Fixed Asset) Company
	Linked Information:  NONE

Additional DAX Measures for PowerPivot and Power BI