DAX Measures – 52/53 Tax Year Data Model

Modified on Wed, 29 Jul at 3:42 AM

Measure Summary

This reference lists the visible DAX measures included in the prepared QQube 52/53 Tax Year examples for Power BI and Excel Power Pivot. The measures support actual, percent-of-sales, period, year-to-date, year, and previous-year comparison analysis across the configured three-year 52/53 Tax Year calendar.

Data Model

52/53 Tax Year

Reference Type

DAX measure reference

Visible Measures

190

Display Folders

Measure Names

Names are shown exactly as they appear in the model. Hidden measures are not included.

Configured 52/53 Tax Year periods

The 39 numbered periods represent the three-year 52/53 Tax Year calendar selected in the QQube Configuration Tool. Their calendar dates depend on that configuration.

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.

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)

Antecedent Measures

Actual and percent-of-sales values for the last completed 52/53 Tax Year period.

Measure Name
.Last Period Actuals
.Last Period Actuals % Sales

Back to Measure Folders

Comparison Measures

Current-versus-previous-year comparisons for the selected period, last completed period, year-to-last-period, and year-to-date values.

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 %

Back to Measure Folders

Current Measures

Actual and percent-of-sales values for the current period, current year, current year-to-last-period, and current year-to-date.

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

Back to Measure Folders

Previous Year Measures

Actual and percent-of-sales values for the previous year, comparable period, last completed period, year-to-last-period, and year-to-date.

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

Back to Measure Folders

Specific Period Measures

Actual, percent-of-sales, year-to-date actual, and year-to-date percent-of-sales measures for each of the 39 configured 52/53 Tax Year periods.

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

Back to Measure Folders

Specific Year Measures

Actual and percent-of-sales measures for each of the three configured 52/53 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

Back to Measure Folders