Profit and Loss by Job by Class Data Model

Modified on Sat, 6 Jul at 10:41 PM

Overview of the QuickBooks Profit and Loss by Job by Class Data Model

The Profit and Loss by Job by Class flexible period data model contains only profit and loss accounts - as opposed to the Job Cost Details data model which contains balance sheet accounts used for expense accruals.


This replaces the Profit and Loss by Job by Class Freestyle option used in earlier versions of QQube. It is more efficient to load, and specifically designed for Power BI and Power Pivot.


Features

  • Over 250 available fields
  • 3 base measures
  • 219 Additional DAX measures for Power/Pivot and Power BI
  • Aggregated by Day for any number of years
  • Actual and Budget
  • Home and Foreign Currencies


Output Examples

  • Profit and Loss by Job by Class
  • Daily, Weekly, Monthly, Yearly or Full Job buckets


Schema

AVAILABLE FIELDSDIMENSION DETAIL LINKS

Dates and Calendar Dimensions:

Document Based Dimensions: 

  • NONE

List Based Dimensions: 

Linked Information: 

  • NONE


Additional DAX Measures for PowerPivot and Power BI

Additional DAX measures for the QQube for QuickBooks Profit and Loss by Job by Class Data Model


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article