Measure Summary
This reference lists the visible DAX measures included in the prepared QQube Profit and Loss by Job Flexible Period examples for Power BI and Excel Power Pivot. The measures support dynamic actual, budget, foreign-currency, percent-of-sales, job, and period-comparison analysis.
Data Model Profit and Loss by Job Flexible Period | Reference Type DAX measure reference |
Visible Measures 201 | Display Folders 9 |
Measure Names Names are shown exactly as they appear in the model. Hidden measures are not included. | |
3 measures are not assigned to a display folder.
These measures support company-specific Account, Customer, and Job slicer filtering in Power BI. Excel Power Pivot handles company 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 (3 measures)
- Antecedent Measures (36 measures)
- Calendar Pattern Measures (13 measures)
- Comparison Measures (18 measures)
- Current Measures (54 measures)
- Job Measures (5 measures)
- Previous Year Measures (54 measures)
- Today Measures (6 measures)
- Tomorrow Measures (6 measures)
- Yesterday Measures (6 measures)
Measures Without a Display Folder
Power BI support measures that filter Account, Customer, and Job slicers by the selected company. Excel Power Pivot handles company filtering automatically.
| Measure Name |
|---|
| Account Slicer: Company Filter |
| Customer Slicer: Company Filter |
| Job Slicer: Company Filter |
Antecedent Measures
Last week, month, and quarter measures for actual, budget, foreign-currency, and percent-of-sales reporting.
| Measure Name |
|---|
| Last Month Actual |
| Last Month Actual % Sales |
| Last Month Budget |
| Last Month Budget % Sales |
| Last Month Foreign |
| Last Month Foreign % Sales |
| Last Month-to-Date Actual |
| Last Month-to-Date Actual % Sales |
| Last Month-to-Date Budget |
| Last Month-to-Date Budget % Sales |
| Last Month-to-Date Foreign |
| Last Month-to-Date Foreign % Sales |
| Last Quarter Actual |
| Last Quarter Actual % Sales |
| Last Quarter Budget |
| Last Quarter Budget % Sales |
| Last Quarter Foreign |
| Last Quarter Foreign % Sales |
| Last Quarter-to-Date Actual |
| Last Quarter-to-Date Actual % Sales |
| Last Quarter-to-Date Budget |
| Last Quarter-to-Date Budget % Sales |
| Last Quarter-to-Date Foreign |
| Last Quarter-to-Date Foreign % Sales |
| Last Week Actual |
| Last Week Actual % Sales |
| Last Week Budget |
| Last Week Budget % Sales |
| Last Week Foreign |
| Last Week Foreign % Sales |
| Last Week-to-Date Actual |
| Last Week-to-Date Actual % Sales |
| Last Week-to-Date Budget |
| Last Week-to-Date Budget % Sales |
| Last Week-to-Date Foreign |
| Last Week-to-Date Foreign % Sales |
Calendar Pattern Measures
Dynamic Profit and Loss measures by week, month, quarter, year, and trailing twelve months.
| Measure Name |
|---|
| Profit and Loss by Month Actual |
| Profit and Loss by Month Budget |
| Profit and Loss By Month Foreign |
| Profit and Loss by Quarter Actual |
| Profit and Loss by Quarter Budget |
| Profit and Loss by Quarter Foreign |
| Profit and Loss by Week Actual |
| Profit and Loss by Week Budget |
| Profit and Loss by Week Foreign |
| Profit and Loss by Year Actual |
| Profit and Loss by Year Budget |
| Profit and Loss by Year Foreign |
| Profit and Loss Trailing Twelve Months |
Comparison Measures
Actual-versus-budget and current-versus-previous comparisons for job and period reporting.
| Measure Name |
|---|
| Compare Job Actual vs Budget |
| Compare Job Actual vs Budget % |
| Compare MTD Current Actual vs Budget |
| Compare MTD Current Actual vs Budget % |
| Compare MTD Current Actual vs Previous |
| Compare MTD Current Actual vs Previous % |
| Compare QTD Current Actual vs Budget |
| Compare QTD Current Actual vs Budget % |
| Compare QTD Current Actual vs Previous |
| Compare QTD Current Actual vs Previous % |
| Compare Year-to-Last Month Current Actual vs Budget |
| Compare Year-to-Last Month Current Actual vs Budget % |
| Compare Year-to-Last Month Current Actual vs Previous |
| Compare Year-to-Last Month Current Actual vs Previous % |
| Compare YTD Current Actual vs Budget |
| Compare YTD Current Actual vs Budget % |
| Compare YTD Current Actual vs Previous |
| Compare YTD Current Actual vs Previous % |
Current Measures
Current week, month, quarter, and year measures for actual, budget, foreign-currency, and percent-of-sales reporting.
| Measure Name |
|---|
| Current Month Actual |
| Current Month Actual % Sales |
| Current Month Budget |
| Current Month Budget % Sales |
| Current Month Foreign |
| Current Month Foreign % Sales |
| Current Month-to-Date Actual |
| Current Month-to-Date Actual % Sales |
| Current Month-to-Date Budget |
| Current Month-to-Date Budget % Sales |
| Current Month-to-Date Foreign |
| Current Month-to-Date Foreign % Sales |
| Current Quarter Actual |
| Current Quarter Actual % Sales |
| Current Quarter Budget |
| Current Quarter Budget % Sales |
| Current Quarter Foreign |
| Current Quarter Foreign % Sales |
| Current Quarter-to-Date Actual |
| Current Quarter-to-Date Actual % Sales |
| Current Quarter-to-Date Budget |
| Current Quarter-to-Date Budget % Sales |
| Current Quarter-to-Date Foreign |
| Current Quarter-to-Date Foreign % Sales |
| Current Week Actual |
| Current Week Actual % Sales |
| Current Week Budget |
| Current Week Budget % Sales |
| Current Week Foreign |
| Current Week Foreign % Sales |
| Current Week-to-Date Actual |
| Current Week-to-Date Actual % Sales |
| Current Week-to-Date Budget |
| Current Week-to-Date Budget % Sales |
| Current Week-to-Date Foreign |
| Current Week-to-Date Foreign % Sales |
| Current Year Actual |
| Current Year Actual % Sales |
| Current Year Budget |
| Current Year Budget % Sales |
| Current Year Foreign |
| Current Year Foreign % Sales |
| Current Year-to-Date Actual |
| Current Year-to-Date Actual % Sales |
| Current Year-to-Date Budget |
| Current Year-to-Date Budget % Sales |
| Current Year-to-Date Foreign |
| Current Year-to-Date Foreign % Sales |
| Current Year-to-Last Month Actual |
| Current Year-to-Last Month Actual % Sales |
| Current Year-to-Last Month Budget |
| Current Year-to-Last Month Budget % Sales |
| Current Year-to-Last Month Foreign |
| Current Year-to-Last Month Foreign % Sales |
Job Measures
Job-level actual, budget, percent-of-sales, and job-cost visual-support measures.
| Measure Name |
|---|
| Job Actual |
| Job Actual % Sales |
| Job Budget |
| Job Budget % Sales |
| Job Cost Bar Color |
Previous Year Measures
Previous-year week, month, quarter, and year measures for actual, budget, foreign-currency, and percent-of-sales reporting.
| Measure Name |
|---|
| Previous Year Actual |
| Previous Year Actual % Sales |
| Previous Year Budget |
| Previous Year Budget % Sales |
| Previous Year Foreign |
| Previous Year Foreign % Sales |
| Previous Year Last Month Actual |
| Previous Year Last Month Actual % Sales |
| Previous Year Last Month Budget |
| Previous Year Last Month Budget % Sales |
| Previous Year Last Month Foreign |
| Previous Year Last Month Foreign % Sales |
| Previous Year Last Quarter Actual |
| Previous Year Last Quarter Actual % Sales |
| Previous Year Last Quarter Budget |
| Previous Year Last Quarter Budget % Sales |
| Previous Year Last Quarter Foreign |
| Previous Year Last Quarter Foreign % Sales |
| Previous Year Month Actual |
| Previous Year Month Actual % Sales |
| Previous Year Month Budget |
| Previous Year Month Budget % Sales |
| Previous Year Month Foreign |
| Previous Year Month Foreign % Sales |
| Previous Year Month-to-Date Actual |
| Previous Year Month-to-Date Actual % Sales |
| Previous Year Month-to-Date Budget |
| Previous Year Month-to-Date Budget % Sales |
| Previous Year Month-to-Date Foreign |
| Previous Year Month-to-Date Foreign % Sales |
| Previous Year Quarter Actual |
| Previous Year Quarter Actual % Sales |
| Previous Year Quarter Budget |
| Previous Year Quarter Budget % Sales |
| Previous Year Quarter Foreign |
| Previous Year Quarter Foreign % Sales |
| Previous Year Quarter-to-Date Actual |
| Previous Year Quarter-to-Date Actual % Sales |
| Previous Year Quarter-to-Date Budget |
| Previous Year Quarter-to-Date Budget % Sales |
| Previous Year Quarter-to-Date Foreign |
| Previous Year Quarter-to-Date Foreign % Sales |
| Previous Year-to-Date Actual |
| Previous Year-to-Date Actual % Sales |
| Previous Year-to-Date Budget |
| Previous Year-to-Date Budget % Sales |
| Previous Year-to-Date Foreign |
| Previous Year-to-Date Foreign % Sales |
| Previous Year-to-Last Month Actual |
| Previous Year-to-Last Month Actual % Sales |
| Previous Year-to-Last Month Budget |
| Previous Year-to-Last Month Budget % Sales |
| Previous Year-to-Last Month Foreign |
| Previous Year-to-Last Month Foreign % Sales |
Today Measures
Actual, budget, foreign-currency, and percent-of-sales measures for today.
| Measure Name |
|---|
| Today Actual |
| Today Actual % Sales |
| Today Budget |
| Today Budget % Sales |
| Today Foreign |
| Today Foreign % Sales |
Tomorrow Measures
Actual, budget, foreign-currency, and percent-of-sales measures for tomorrow.
| Measure Name |
|---|
| Tomorrow Actual |
| Tomorrow Actual % Sales |
| Tomorrow Budget |
| Tomorrow Budget % Sales |
| Tomorrow Foreign |
| Tomorrow Foreign % Sales |
Yesterday Measures
Actual, budget, foreign-currency, and percent-of-sales measures for yesterday.
| Measure Name |
|---|
| Yesterday Actual |
| Yesterday Actual % Sales |
| Yesterday Budget |
| Yesterday Budget % Sales |
| Yesterday Foreign |
| Yesterday Foreign % Sales |
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