Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Trial Balance Activity examples for Power BI and Excel Power Pivot. The measures support beginning balances, ending balances, debit activity, credit activity, actual values, budget values, and period comparisons.
Data Model Trial Balance Activity | Reference Type DAX measure reference |
Visible Measures 343 | Display Folders 4 |
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 (14 measures)
- Current Measures (14 measures)
- Previous Year Measures (14 measures)
- Specific Period Measures (301 measures)
Antecedent Measures
Last-period activity, beginning Trial Balance, ending Trial Balance, debit, credit, actual, and budget calculations.
| Measure Name |
|---|
| .Last Period Activity Amount |
| .Last Period Activity Budget |
| .Last Period Beginning Credit Amount |
| .Last Period Beginning Credit Budget |
| .Last Period Beginning Debit Amount |
| .Last Period Beginning Debit Budget |
| .Last Period Beginning TB Amount |
| .Last Period Beginning TB Budget |
| .Last Period Ending Credit Amount |
| .Last Period Ending Credit Budget |
| .Last Period Ending Debit Amount |
| .Last Period Ending Debit Budget |
| .Last Period Ending TB Amount |
| .Last Period Ending TB Budget |
Current Measures
Current-period activity, beginning Trial Balance, ending Trial Balance, debit, credit, actual, and budget calculations.
| Measure Name |
|---|
| .Current Activity Amount |
| .Current Activity Budget |
| .Current Beginning Credit Amount |
| .Current Beginning Credit Budget |
| .Current Beginning Debit Amount |
| .Current Beginning Debit Budget |
| .Current Beginning TB Amount |
| .Current Beginning TB Budget |
| .Current Ending Credit Amount |
| .Current Ending Credit Budget |
| .Current Ending Debit Amount |
| .Current Ending Debit Budget |
| .Current Ending TB Amount |
| .Current Ending TB Budget |
Previous Year Measures
Previous-year activity, beginning Trial Balance, ending Trial Balance, debit, credit, actual, and budget calculations.
| Measure Name |
|---|
| .Previous Year Activity Amount |
| .Previous Year Activity Budget |
| .Previous Year Beginning Credit Amount |
| .Previous Year Beginning Credit Budget |
| .Previous Year Beginning Debit Amount |
| .Previous Year Beginning Debit Budget |
| .Previous Year Beginning TB Amount |
| .Previous Year Beginning TB Budget |
| .Previous Year Ending Credit Amount |
| .Previous Year Ending Credit Budget |
| .Previous Year Ending Debit Amount |
| .Previous Year Ending Debit Budget |
| .Previous Year Ending TB Amount |
| .Previous Year Ending TB Budget |
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 Activity Budget |
| Periods 01-36 Ending Credit Amount |
| Periods 01-36 Ending Credit Budget |
| Periods 01-36 Ending Debit Amount |
| Periods 01-36 Ending Debit Budget |
| Periods 01-36 Ending TB Amount |
| Periods 01-36 Ending TB Budget |
| Period 01 Beginning TB Amount |
| Period 01 Beginning TB Budget |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article