Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Balance Sheet Flexible Period examples for Power BI and Excel Power Pivot. The measures support actual, budget, foreign-currency, period comparison, liquidity, and working-capital analysis.
Data Model Balance Sheet Flexible Period | Reference Type DAX measure reference |
Visible Measures 74 | Display Folders 7 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
1 measure is not assigned to a display folder.
The Account Slicer company-filter measure supports company-specific Account selections in Power BI. Excel Power Pivot handles this filtering automatically.
DAX formulas and methodology
For the calculation methods and supporting patterns used in QQube, see DAX Methods Used in PowerPivot and Power BI.
Measure Sections
The measures are grouped below according to their placement in Power BI and Excel Power Pivot.
- Measures Without a Display Folder (1 measure)
- Antecedent Measures (12 measures)
- Calendar Pattern Measures (3 measures)
- Comparison Measures (14 measures)
- Current Measures (20 measures)
- Previous Year Measures (18 measures)
- Tomorrow Measures (3 measures)
- Yesterday Measures (3 measures)
Measures Without a Display Folder
Power BI support measures used to filter the Account slicer by the selected company. Excel Power Pivot handles company filtering automatically.
| Measure Name |
|---|
| Account Slicer: Company Filter |
Antecedent Measures
Last-month, month-to-date, quarter, and week actual, budget, and foreign-currency calculations.
| Measure Name |
|---|
| Last Month Actual |
| Last Month Budget |
| Last Month Foreign |
| Last Month-to-Date Actual |
| Last Month-to-Date Budget |
| Last Month-to-Date Foreign |
| Last Quarter Actual |
| Last Quarter Budget |
| Last Quarter Foreign |
| Last Week Actual |
| Last Week Budget |
| Last Week Foreign |
Calendar Pattern Measures
Balance Sheet actual, budget, and foreign-currency calculations using the active calendar context.
| Measure Name |
|---|
| Balance Sheet Actual |
| Balance Sheet Budget |
| Balance Sheet Foreign |
Comparison Measures
Current year-to-date, budget, prior-period, previous-year, and percentage comparisons.
| Measure Name |
|---|
| Compare Current YTD to Budget YTD |
| Compare Current YTD to Budget YTD % |
| Compare Current YTD to Last MTD |
| Compare Current YTD to Last MTD % |
| Compare Current YTD to Last Quarter |
| Compare Current YTD to Last Quarter % |
| Compare Current YTD to Previous Year |
| Compare Current YTD to Previous Year % |
| Compare Current YTD to Previous YTD |
| Compare Current YTD to Previous YTD % |
| Compare Last Month to Previous Year Last Month |
| Compare Last Month to Previous Year Last Month % |
| Compare Last Quarter to Previous Year Last Quarter |
| Compare Last Quarter to Previous Year Last Quarter % |
Current Measures
Current month, quarter, year, year-to-date, current assets, current liabilities, current ratio, and working-capital calculations.
| Measure Name |
|---|
| Current Month Actual |
| Current Month Budget |
| Current Month Foreign |
| Current Quarter Actual |
| Current Quarter Budget |
| Current Quarter Foreign |
| Current Year Actual |
| Current Year Budget |
| Current Year Foreign |
| Current Year-to-Date Actual |
| Current Year-to-Date Budget |
| Current Year-to-Date Foreign |
| Current YTD Current Assets Actual |
| Current YTD Current Assets Budget |
| Current YTD Current Liabilities Actual |
| Current YTD Current Liabilities Budget |
| Current YTD Current Ratio Actual |
| Current YTD Current Ratio Budget |
| Current YTD Working Capital Actual |
| Current YTD Working Capital Budget |
Previous Year Measures
Previous-year month, quarter, year, and year-to-date actual, budget, and foreign-currency calculations.
| Measure Name |
|---|
| Previous Year Actual |
| Previous Year Budget |
| Previous Year Foreign |
| Previous Year Last Month Actual |
| Previous Year Last Month Budget |
| Previous Year Last Month Foreign |
| Previous Year Last Quarter Actual |
| Previous Year Last Quarter Budget |
| Previous Year Last Quarter Foreign |
| Previous Year Month Actual |
| Previous Year Month Budget |
| Previous Year Month Foreign |
| Previous Year Quarter Actual |
| Previous Year Quarter Budget |
| Previous Year Quarter Foreign |
| Previous Year-to-Date Actual |
| Previous Year-to-Date Budget |
| Previous Year-to-Date Foreign |
Tomorrow Measures
Actual, budget, and foreign-currency values for tomorrow.
| Measure Name |
|---|
| Tomorrow Actual |
| Tomorrow Budget |
| Tomorrow Foreign |
Yesterday Measures
Actual, budget, and foreign-currency values for yesterday.
| Measure Name |
|---|
| Yesterday Actual |
| Yesterday Budget |
| Yesterday Foreign |
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