Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Statement of Cash Flow Standard Period examples for Power BI and Excel Power Pivot. The measures support beginning balances, cash activity, ending balances, monthly-period analysis, and current, prior, and previous-year comparisons across three financial years.
Data Model Statement of Cash Flow Monthly Period | Reference Type DAX measure reference |
Visible Measures 88 | Display Folders 2 |
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 across three financial years. Beginning Balance measures are provided at Periods 01, 13, and 25.
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 (4 measures)
- Period/Month Measures (84 measures)
Comparison Measures
Cash-activity comparisons between the current period, last period, and previous-year period, including percentage differences.
| Measure Name |
|---|
| Compare Cash Activity - Current Period vs Last Period |
| Compare Cash Activity - Current Period vs Last Period % |
| Compare Cash Activity - Current Period vs Previous Year Period |
| Compare Cash Activity - Current Period vs Previous Year Period % |
Period/Month Measures
Current, last, and previous-year period measures are listed by exact name. Repeating cash-activity and ending-balance measures are summarized for Periods 01-36. Beginning Balance is summarized for the three financial-year starting periods.
| Measure Name or Classification |
|---|
| Current Period Beginning Balance |
| Current Period Cash Activity |
| Current Period Ending Balance |
| Last Period Beginning Balance |
| Last Period Cash Activity |
| Last Period Ending Balance |
| Periods 01, 13, and 25 Beginning Balance |
| Periods 01-36 Cash Activity |
| Periods 01-36 Ending Balance |
| Previous Year Period Beginning Balance |
| Previous Year Period Cash Activity |
| Previous Year Period Ending Balance |
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