Profit and Loss (Standard Period) Data Model

Modified on Wed, 29 Jul at 8:14 PM

Model Summary

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

Model Type	Three-year Profit and Loss 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 traditional Profit and Loss results across three financial years

Best Used For

Preparing a traditional three-year Profit and Loss statement.
Comparing Actual and Budget values.
Reviewing monthly, quarterly, yearly, and year-to-date results.
Analyzing Actual and Budget values as a percentage of Sales.
Using fixed shortcuts such as Current Month, Last Month, and Previous Year Month.
Building Excel PivotTable, Power BI, and Excel Power Pivot financial reports.

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.
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 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	60
Year Measures	48

Included Dimensions

Lists

Account (Profit and Loss)

Company

Technical Details

Model Structure	One prepared Profit and Loss Standard Period table with related Account and Company dimensions
Financial Model Type	Three-year standard financial statement
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 using Actual, Budget, percent-of-sales, monthly, quarterly, yearly, and year-to-date values.

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