Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Statement of Cash Flow by Class Standard Period examples for Power BI and Excel Power Pivot. The measures support beginning balances, cash activity, ending balances, monthly-period comparisons, and Class analysis across three financial years.
Data Model Statement of Cash Flow by Class Standard Period | Reference Type DAX measure reference |
Visible Measures 86 | Display Folders 2 |
Measure Names The leading Statement of Cash Flow icon has been removed from the displayed names. Hidden measures are not included. Repeating period measures are summarized by range. | |
Three-year financial statement measures
The prepared model contains 36 monthly periods across three financial years, with results available by Class. 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 (2 measures)
- Period/Month Measures (84 measures)
Comparison Measures
Cash-activity comparisons between the current period, last period, and previous-year period.
| Measure Name |
|---|
| Compare Cash Activity - Current Period vs Last Period |
| Compare Cash Activity - Current Period vs Previous Year Period |
Period/Month Measures
Current, last, and previous-year period measures are listed by 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