These are specific time period calculations that are appropriate in the following areas:
The big difference between the 📅 Calendar Pattern Measures and the Calendar Specific Measures is that the 📅 Calendar Pattern Measures cover complete time periods, e.g. Year, Month whereas the Calendar Specific Measures generally cover aggregation of data up to a "today" or "to-date" period, e.g. Year-to-Date, or Month-to-Date - OR - aggregation of a specific whole time period e.g. Current Month, Last Month, Previous Year Month.
NOTE: Today's date is configured in the QQube Configuration Tool
Here is a list of measures which are used in almost all data models. The majority are based upon transaction date. However Vehicle Mileage is based upon Trip End Date, and Payroll is based upon Effective Payroll Date.
These would be used (along with others) for:
These are used specifically in the Inventory Data Model
Current Month Actual =IF ( [[DAXP]] ShowValueForDates], VAR todayselection = [[DAXP]] Today Selection] VAR LastMonthAvailable = CALCULATE ( MAX ( 'Calendar'[Year Month Number] ), 'Calendar'[Date] = todayselection ) VAR Result = CALCULATE ( [.Hierarchy Actual], ALLEXCEPT ( 'Calendar', 'Calendar'[Day Holiday Name], 'Calendar'[Day is Working Day], 'Calendar'[Day of Week Abbr] ), 'Calendar'[Year Month Number] = LastMonthAvailable, ALL ( 'Calendar' ) ) RETURN Result)
Current Month-to-Date Actual =IF ( [[DAXP]] ShowValueForDates], VAR todayselection = [[DAXP]] Today Selection] VAR LastMonthAvailable = CALCULATE ( MAX ( 'Calendar'[Year Month Number] ), 'Calendar'[Date] = todayselection ) VAR Result = CALCULATE ( [.Hierarchy Actual], ALLEXCEPT ( 'Calendar', 'Calendar'[Day Holiday Name], 'Calendar'[Day is Working Day], 'Calendar'[Day of Week Abbr] ), 'Calendar'[Year Month Number] = LastMonthAvailable, 'Calendar'[SequentialDayNumber] <= todayselection, ALL ( 'Calendar' ) ) RETURN Result)
As iterated in DAX Pattern Measures, we use three filter-safe columns which are always preserved regardless of all other filters applied to a measure:
We added 'Day is Working Day' in Version 10
Please enable JavaScript to use file uploader.
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6129/calendar-specific-measures
Your session has expired. You are being logged out.