DAX Measures – Trial Balance Data Model

Modified on Wed, 29 Jul at 4:06 AM

Measure Summary

This reference lists the visible DAX measures included in the prepared QQube Trial Balance examples for Power BI and Excel Power Pivot. The measures support Trial Balance amount, debit, credit, and account-hierarchy analysis.

Data Model

Trial Balance

Reference Type

DAX measure reference

Visible Measures

Display Folders

Measure Names

Names are shown exactly as they appear in the model. Hidden measures are not included.

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.

.Base Measures (3 measures)
.Base Measures For Hierarchies (3 measures)

.Base Measures

Base calculations for Trial Balance amount, debit, and credit values.

Measure Name
.Amount
.Credit
.Debit

Back to Measure Folders

.Base Measures For Hierarchies

Hierarchy-aware amount, debit, and credit calculations used with the prepared Trial Balance account structure.

Measure Name
.Hierarchy Amount
.Hierarchy Credit
.Hierarchy Debit

Back to Measure Folders