The Weeks: General timescale has no concept of financial years, only weeks. This means that you cannot include Year, Year to Date (YTD), or Year To Go (YTG) summaries.
However, you can use Current Period in calculations that use the CURRENTPERIODSTART and CURRENTPERIODEND functions.
To set the Weeks: General calendar type:
- Select Time in the model settings bar.
- Select Weeks: General in Calendar Type.
Weeks: General options
You can set the following options:
Start Date
Select the calendar start date.
Number of Weeks
Type the total number of weeks that you want to include in the calendar.
Current Period
You typically set Current Period to the last time period for actual version data.
A benefit of setting Current Period is that you can refer to it in formulas instead of hard coding the specific time period. For example, you could use:
Revenue.Data[SELECT: TIME.'Current Period']
You can also use these functions:
CURRENTPERIODSTARTto return the start date of the current periodCURRENTPERIODENDto return the end date of the current period
If Current Period is not set, the formula returns a blank value.
You can update the Current Period via the Update Current Period action, as well as the Model Calendar. This lets you set the current period using a line item with a Time Period data type, and import the Current Period from a data hub.
