Profit and Loss by Class (Standard Period) Data Model

Modified on Wed, 29 Jul at 8:33 PM

Model Summary

The QQube Profit and Loss by Class Standard Period Data Model provides a traditional three-year Profit and Loss statement with Actual, Budget, and percent-of-sales values analyzed by Class. It includes fixed shortcut measures and 36 configured monthly periods.

Model Type	Three-year Profit and Loss by Class Standard Period financial statement
Period Coverage	36 monthly periods controlled in the QQube Configuration Tool
Primary Values	Actuals, Budget, Actuals % Sales, and Budget % Sales
Prepared Excel Measures	404
Visible DAX Measures	452
Primary Use	Prepare and compare Profit and Loss results by Class across three financial years

Best Used For

Preparing a traditional three-year Profit and Loss statement by Class.
Comparing Actual and Budget values by Class.
Reviewing monthly, quarterly, yearly, and year-to-date results.
Analyzing Actual and Budget values as a percentage of Sales.
Displaying Classes side by side or across report columns.
Using fixed shortcuts such as Current Month, Last Month, and Previous Year Month.

Key Capabilities

Includes 36 monthly periods across three years.
Provides 56 current, prior-period, and previous-year shortcut measures.
Includes monthly, year-to-date, quarterly, and yearly Actual and Budget measures.
Includes corresponding Actuals % Sales and Budget % Sales measures.
Supports filtering and comparison by Class.
Includes 404 prepared Excel measures.
Provides 452 visible DAX measures for Power BI and Excel Power Pivot.
Provides special Microsoft Access views for the wide financial structure.

Three-Year Period Logic

The 36 monthly periods are controlled in the QQube Configuration Tool.

The displayed month and year labels change with the configured financial reporting range. The prepared model retains the same measure structure for Periods 01 through 36, Quarters 1 through 4 for each of three years, and Years 1 through 3.

Prepared Excel Measures

The Excel and Excel PivotTable model includes 404 prepared measures. Repeating monthly, quarterly, and yearly measures are summarized below instead of listing every dated field separately.

Shortcut Measures (56)

Current Measures	Previous and Prior-Period Measures
Current Month Actuals and Budget Current Quarter Actuals and Budget Current Year Actuals and Budget Current Year-to-Last Month Actuals and Budget Current YTD Actuals and Budget Each value includes a corresponding % Sales measure	Last Month Actuals and Budget Last Quarter Actuals and Budget Previous Year Month Actuals and Budget Previous Year Quarter Actuals and Budget Previous Year Actuals and Budget Previous Year-to-Last Month Actuals and Budget Previous YTD Actuals and Budget Previous Year Last Month Actuals and Budget Previous Year Last Quarter Actuals and Budget Each value includes a corresponding % Sales measure

Specific Monthly Period Measures (144)

Actuals	Budget	Percent of Sales
Periods 01-36 Actuals	Periods 01-36 Budget	Periods 01-36 Actuals % Sales Periods 01-36 Budget % Sales

Specific Year-to-Date Measures (144)

Actuals	Budget	Percent of Sales
Periods 01-36 YTD Actuals	Periods 01-36 YTD Budget	Periods 01-36 YTD Actuals % Sales Periods 01-36 YTD Budget % Sales

Specific Quarter Measures (48)

Actuals	Budget	Percent of Sales
Quarters 1-4 for Years 1-3 Actuals	Quarters 1-4 for Years 1-3 Budget	Quarters 1-4 for Years 1-3 Actuals % Sales Quarters 1-4 for Years 1-3 Budget % Sales

Specific Year Measures (12)

Actuals	Budget	Percent of Sales
Years 1-3 Actuals	Years 1-3 Budget	Years 1-3 Actuals % Sales Years 1-3 Budget % Sales

Power BI and Excel Power Pivot Measures

The prepared Profit and Loss by Class Standard Period examples include 452 visible DAX measures in four display folders. Hidden measures are not included.

Measure Folder	Visible Measures
Comparison Measures	48
Period/Month Measures	296
Quarter Measures	64
Year Measures	44

Included Dimensions

Lists

Account (Profit and Loss)

Class

Company

Technical Details

Model Structure	One prepared Profit and Loss by Class Standard Period table with related Account, Class, and Company dimensions
Financial Model Type	Three-year standard financial statement by Class
Aggregation	Monthly
Period Range	36 configured monthly periods
Excel Availability	Available for Excel and Excel PivotTables
Prepared Excel Measures	404
DAX Support	452 visible measures for Power BI and Excel Power Pivot
Microsoft Access	Special views are included for the wide financial structure

Expected Result

Customers can immediately build a traditional three-year Profit and Loss statement by Class using Actual, Budget, percent-of-sales, monthly, quarterly, yearly, and year-to-date values.

The prepared financial statement table, Account, Class, and Company dimensions, relationships, 404 Excel measures, and 452 visible DAX measures are already included.