DAX Measures – Trial Balance Activity by Class Data Model

Modified on Wed, 29 Jul at 4:34 AM

Measure Summary

This reference lists the visible DAX measures included in the prepared QQube Trial Balance Activity by Class examples for Power BI and Excel Power Pivot. The measures support beginning balances, ending balances, debit activity, credit activity, actual values, and period comparisons by class.

Data Model

Trial Balance Activity by Class

Reference Type

DAX measure reference

Visible Measures

166

Display Folders

Measure Names

Names are shown exactly as they appear in the model. Hidden measures are not included. Repeating period measures are summarized by range.

DAX formulas and methodology

For the calculation methods and supporting patterns used in QQube, see DAX Methods Used in PowerPivot and Power BI.

Measure Folders

The measures are grouped below according to their placement in Power BI and Excel Power Pivot.

Antecedent Measures (7 measures)
Current Measures (7 measures)
Previous Year Measures (7 measures)
Specific Period Measures (145 measures)

Antecedent Measures

Last-period activity, beginning Trial Balance, ending Trial Balance, debit, credit, and actual calculations.

Measure Name
.Last Period Activity Amount
.Last Period Beginning Credit Amount
.Last Period Beginning Debit Amount
.Last Period Beginning TB Amount
.Last Period Ending Credit Amount
.Last Period Ending Debit Amount
.Last Period Ending TB Amount

Back to Measure Folders

Current Measures

Current-period activity, beginning Trial Balance, ending Trial Balance, debit, credit, and actual calculations.

Measure Name
.Current Activity Amount
.Current Beginning Credit Amount
.Current Beginning Debit Amount
.Current Beginning TB Amount
.Current Ending Credit Amount
.Current Ending Debit Amount
.Current Ending TB Amount

Back to Measure Folders

Previous Year Measures

Previous-year activity, beginning Trial Balance, ending Trial Balance, debit, credit, and actual calculations.

Measure Name
.Previous Year Activity Amount
.Previous Year Beginning Credit Amount
.Previous Year Beginning Debit Amount
.Previous Year Beginning TB Amount
.Previous Year Ending Credit Amount
.Previous Year Ending Debit Amount
.Previous Year Ending TB Amount

Back to Measure Folders

Specific Period Measures

Period-specific activity and ending-balance calculations across the configured three-year range.

Measure Classification
Periods 01-36 Activity Amount
Periods 01-36 Ending Credit Amount
Periods 01-36 Ending Debit Amount
Periods 01-36 Ending TB Amount
Period 01 Beginning TB Amount

Back to Measure Folders