1. Modeling
  2. Dimensions
  3. Time
  4. Set the model calendar
  5. Set the Weeks: General calendar

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:

  1. Select Time in the model settings bar.
  2. 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:

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.