Measure Summary
This reference lists the visible DAX measures included in the prepared QQube 52/53 Tax Year by Class examples for Power BI and Excel Power Pivot. The measures support actual, percent-of-sales, period, year-to-date, previous-year, and class-based 52/53 tax-year analysis.
Data Model 52/53 Tax Year by Class | Reference Type DAX measure reference |
Visible Measures 191 | Display Folders 6 |
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 Class Slicer company-filter measure supports company-specific Class 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 (2 measures)
- Comparison Measures (8 measures)
- Current Measures (8 measures)
- Previous Year Measures (10 measures)
- Specific Period Measures (156 measures)
- Specific Year Measures (6 measures)
Measures Without a Display Folder
Power BI support measures used to filter the Class slicer by the selected company. Excel Power Pivot handles company filtering automatically.
| Measure Name |
|---|
| Class Slicer: Company Filter |
Antecedent Measures
Last-period actual and percent-of-sales calculations.
| Measure Name |
|---|
| .Last Period Actuals |
| .Last Period Actuals % Sales |
Comparison Measures
Current-period and year-to-date actual comparisons with related previous-year periods.
| Measure Name |
|---|
| Compare Actual - Current Period vs Previous Year Period |
| Compare Actual - Current Period vs Previous Year Period % |
| Compare Actual - Current Year-to-Last Period vs Previous Year-to-Last Period |
| Compare Actual - Current Year-to-Last Period vs Previous Year-to-Last Period % |
| Compare Actual - Current YTD vs Previous YTD |
| Compare Actual - Current YTD vs Previous YTD % |
| Compare Actual - Last Period vs Previous Year Last Period |
| Compare Actual - Last Period vs Previous Year Last Period % |
Current Measures
Current period, current year, year-to-last-period, and year-to-date actual and percent-of-sales calculations.
| Measure Name |
|---|
| .Current Period Actuals |
| .Current Period Actuals % Sales |
| .Current Year Actuals |
| .Current Year Actuals % Sales |
| .Current Year-to-Last Period Actuals |
| .Current Year-to-Last Period Actuals % Sales |
| .Current YTD Actuals |
| .Current YTD Actuals % Sales |
Previous Year Measures
Previous-year period, year, last-period, year-to-last-period, and year-to-date actual and percent-of-sales calculations.
| Measure Name |
|---|
| .Previous Year Actuals |
| .Previous Year Actuals % Sales |
| .Previous Year Last Period Actuals |
| .Previous Year Last Period Actuals % Sales |
| .Previous Year Period Actuals |
| .Previous Year Period Actuals % Sales |
| .Previous Year-to-Last Period Actuals |
| .Previous Year-to-Last Period Actuals % Sales |
| .Previous YTD Actuals |
| .Previous YTD Actuals % Sales |
Specific Period Measures
Actual, year-to-date actual, and related percent-of-sales calculations for each configured 52/53 tax period.
| Measure Name |
|---|
| .Period 01 Actuals |
| .Period 01 Actuals % Sales |
| .Period 01 YTD Actuals |
| .Period 01 YTD Actuals % Sales |
| .Period 02 Actuals |
| .Period 02 Actuals % Sales |
| .Period 02 YTD Actuals |
| .Period 02 YTD Actuals % Sales |
| .Period 03 Actuals |
| .Period 03 Actuals % Sales |
| .Period 03 YTD Actuals |
| .Period 03 YTD Actuals % Sales |
| .Period 04 Actuals |
| .Period 04 Actuals % Sales |
| .Period 04 YTD Actuals |
| .Period 04 YTD Actuals % Sales |
| .Period 05 Actuals |
| .Period 05 Actuals % Sales |
| .Period 05 YTD Actuals |
| .Period 05 YTD Actuals % Sales |
| .Period 06 Actuals |
| .Period 06 Actuals % Sales |
| .Period 06 YTD Actuals |
| .Period 06 YTD Actuals % Sales |
| .Period 07 Actuals |
| .Period 07 Actuals % Sales |
| .Period 07 YTD Actuals |
| .Period 07 YTD Actuals % Sales |
| .Period 08 Actuals |
| .Period 08 Actuals % Sales |
| .Period 08 YTD Actuals |
| .Period 08 YTD Actuals % Sales |
| .Period 09 Actuals |
| .Period 09 Actuals % Sales |
| .Period 09 YTD Actuals |
| .Period 09 YTD Actuals % Sales |
| .Period 10 Actuals |
| .Period 10 Actuals % Sales |
| .Period 10 YTD Actuals |
| .Period 10 YTD Actuals % Sales |
| .Period 11 Actuals |
| .Period 11 Actuals % Sales |
| .Period 11 YTD Actuals |
| .Period 11 YTD Actuals % Sales |
| .Period 12 Actuals |
| .Period 12 Actuals % Sales |
| .Period 12 YTD Actuals |
| .Period 12 YTD Actuals % Sales |
| .Period 13 Actuals |
| .Period 13 Actuals % Sales |
| .Period 13 YTD Actuals |
| .Period 13 YTD Actuals % Sales |
| .Period 14 Actuals |
| .Period 14 Actuals % Sales |
| .Period 14 YTD Actuals |
| .Period 14 YTD Actuals % Sales |
| .Period 15 Actuals |
| .Period 15 Actuals % Sales |
| .Period 15 YTD Actuals |
| .Period 15 YTD Actuals % Sales |
| .Period 16 Actuals |
| .Period 16 Actuals % Sales |
| .Period 16 YTD Actuals |
| .Period 16 YTD Actuals % Sales |
| .Period 17 Actuals |
| .Period 17 Actuals % Sales |
| .Period 17 YTD Actuals |
| .Period 17 YTD Actuals % Sales |
| .Period 18 Actuals |
| .Period 18 Actuals % Sales |
| .Period 18 YTD Actuals |
| .Period 18 YTD Actuals % Sales |
| .Period 19 Actuals |
| .Period 19 Actuals % Sales |
| .Period 19 YTD Actuals |
| .Period 19 YTD Actuals % Sales |
| .Period 20 Actuals |
| .Period 20 Actuals % Sales |
| .Period 20 YTD Actuals |
| .Period 20 YTD Actuals % Sales |
| .Period 21 Actuals |
| .Period 21 Actuals % Sales |
| .Period 21 YTD Actuals |
| .Period 21 YTD Actuals % Sales |
| .Period 22 Actuals |
| .Period 22 Actuals % Sales |
| .Period 22 YTD Actuals |
| .Period 22 YTD Actuals % Sales |
| .Period 23 Actuals |
| .Period 23 Actuals % Sales |
| .Period 23 YTD Actuals |
| .Period 23 YTD Actuals % Sales |
| .Period 24 Actuals |
| .Period 24 Actuals % Sales |
| .Period 24 YTD Actuals |
| .Period 24 YTD Actuals % Sales |
| .Period 25 Actuals |
| .Period 25 Actuals % Sales |
| .Period 25 YTD Actuals |
| .Period 25 YTD Actuals % Sales |
| .Period 26 Actuals |
| .Period 26 Actuals % Sales |
| .Period 26 YTD Actuals |
| .Period 26 YTD Actuals % Sales |
| .Period 27 Actuals |
| .Period 27 Actuals % Sales |
| .Period 27 YTD Actuals |
| .Period 27 YTD Actuals % Sales |
| .Period 28 Actuals |
| .Period 28 Actuals % Sales |
| .Period 28 YTD Actuals |
| .Period 28 YTD Actuals % Sales |
| .Period 29 Actuals |
| .Period 29 Actuals % Sales |
| .Period 29 YTD Actuals |
| .Period 29 YTD Actuals % Sales |
| .Period 30 Actuals |
| .Period 30 Actuals % Sales |
| .Period 30 YTD Actuals |
| .Period 30 YTD Actuals % Sales |
| .Period 31 Actuals |
| .Period 31 Actuals % Sales |
| .Period 31 YTD Actuals |
| .Period 31 YTD Actuals % Sales |
| .Period 32 Actuals |
| .Period 32 Actuals % Sales |
| .Period 32 YTD Actuals |
| .Period 32 YTD Actuals % Sales |
| .Period 33 Actuals |
| .Period 33 Actuals % Sales |
| .Period 33 YTD Actuals |
| .Period 33 YTD Actuals % Sales |
| .Period 34 Actuals |
| .Period 34 Actuals % Sales |
| .Period 34 YTD Actuals |
| .Period 34 YTD Actuals % Sales |
| .Period 35 Actuals |
| .Period 35 Actuals % Sales |
| .Period 35 YTD Actuals |
| .Period 35 YTD Actuals % Sales |
| .Period 36 Actuals |
| .Period 36 Actuals % Sales |
| .Period 36 YTD Actuals |
| .Period 36 YTD Actuals % Sales |
| .Period 37 Actuals |
| .Period 37 Actuals % Sales |
| .Period 37 YTD Actuals |
| .Period 37 YTD Actuals % Sales |
| .Period 38 Actuals |
| .Period 38 Actuals % Sales |
| .Period 38 YTD Actuals |
| .Period 38 YTD Actuals % Sales |
| .Period 39 Actuals |
| .Period 39 Actuals % Sales |
| .Period 39 YTD Actuals |
| .Period 39 YTD Actuals % Sales |
Specific Year Measures
Actual and percent-of-sales calculations for each of the three configured tax years.
| Measure Name |
|---|
| .Year 01 Actuals |
| .Year 01 Actuals % Sales |
| .Year 02 Actuals |
| .Year 02 Actuals % Sales |
| .Year 03 Actuals |
| .Year 03 Actuals % 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