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:
Timescale
Timescale can be set in a:
- 2-digit format: Allows you to plan up to 2078.
- 4-digit format: Allows you to plan up to 100 years into the future from the set start date.
This setting also changes how the Current Fiscal Year and Current Period fields display. For example, if you select a 2-digit format, Fiscal Year 26 will display as FY26. If you select a 4-digit format, it'll display as FY2026. If your current period is January 2025, it'll display as Jan 25 for a 2-digit format, and Jan 2025 for a 4-digit format.
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.