Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Balance Sheet by Class Standard Period examples for Power BI and Excel Power Pivot. The measures support actual, liquidity, working-capital, monthly, quarterly, yearly, comparison, and Class analysis across three financial years.
Data Model Balance Sheet by Class Standard Period | Reference Type DAX measure reference |
Visible Measures 73 | Display Folders 4 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. Repeating period, quarter, and year measures are summarized by range. | |
Three-year financial statement measures
The prepared model contains 36 monthly periods, 12 quarters, and three financial years, with results available by Class.
Actual-only by-Class measures
Budget measures are not included in this Balance Sheet by Class model.
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.
- Comparison Measures (8 measures)
- Period/Month Measures (44 measures)
- Quarter Measures (16 measures)
- Year Measures (5 measures)
Comparison Measures
Actual comparisons across current, prior, and previous-year months and quarters, including percentage differences.
| Measure Name |
|---|
| ≡ Compare Actual - Current Month vs Previous Year Month |
| ≡ Compare Actual - Current Month vs Previous Year Month % |
| ≡ Compare Actual - Current Quarter vs Previous Year Quarter |
| ≡ Compare Actual - Current Quarter vs Previous Year Quarter % |
| ≡ Compare Actual - Last Month vs Previous Year Last Month |
| ≡ Compare Actual - Last Month vs Previous Year Last Month % |
| ≡ Compare Actual - Last Quarter vs Previous Year Last Quarter |
| ≡ Compare Actual - Last Quarter vs Previous Year Last Quarter % |
Period/Month Measures
Current, last, and previous-year month measures are listed by exact name. The repeating Period 01-36 actual measures are summarized by classification.
| Measure Name or Classification |
|---|
| ≡ Current Month Actuals |
| ≡ Current Month Current Assets |
| ≡ Current Month Current Liabilities |
| ≡ Current Month Current Ratio |
| ≡ Current Month Working Capital |
| ≡ Last Month Actuals |
| Periods 01-36 Actuals |
| ≡ Previous Year Last Month Actuals |
| ≡ Previous Year Month Actuals |
Quarter Measures
Current, last, and previous-year quarter measures are listed by exact name. The repeating Quarter 01-12 actual measures are summarized by classification.
| Measure Name or Classification |
|---|
| ≡ Current Quarter Actuals |
| ≡ Last Quarter Actuals |
| ≡ Previous Year Last Quarter Actuals |
| ≡ Previous Year Quarter Actuals |
| Quarters 01-12 Actuals |
Year Measures
Current-year and previous-year measures are listed by exact name. The repeating Year 01-03 actual measures are summarized by classification.
| Measure Name or Classification |
|---|
| ≡ Current Year Actuals |
| ≡ Previous Year Actuals |
| Years 01-03 Actuals |
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