Fiscal Dates

In some situations, a date field needs to be expressed in terms of an organization's fiscal year. Calendar years run from January 1st until December 31st, but an organization’s fiscal year might start in a different month. For example, a company’s fiscal year might run from June 1st through May 31st. In such cases, it’s appropriate to display some date values in a view using fiscal equivalents (Fiscal Year, Fiscal Quarter, and Fiscal Week Number) rather than their calendar equivalents.

To set the fiscal year start month for a data source, follow these steps:

  1. Right-click (Control-click on Mac) the data source in the Data pane to open the Date Properties dialog box.

  2. Set the Fiscal year start field to the appropriate month.

For each date dimension, you set the fiscal year start-month separately. In the Data pane, right-click a date dimension (Ctrl-click on Mac), and select Default Properties > Fiscal Year Start.

Note: Date functions do not take account of the configured fiscal year start. See Date Functions.

Note: Relative Date filters do not take account of the configured fiscal year start.

Whether a given level of a date dimension is affected by the use of the Fiscal Calendar depends on the specific case.

Date Level When Converted to Fiscal
Year Reflects the fiscal year. For example, if Fiscal year start is set to April, the year for the date June 1, 2004 would be shown as FY 2005.
Quarter

The Quarter reflects the fiscal quarter. For example, if Fiscal year start is set to April, the quarter for the date June 1, 2004 would be Q1.

Month No change in behavior. The calendar month is the same as the fiscal month.
Day No change in behavior. The calendar day is the same as the fiscal day.
Hour No change in behavior. The calendar hour is the same as the fiscal hour.
Minute No change in behavior. The calendar minute is the same as the fiscal minute.
Second No change in behavior. The calendar second is the same as the fiscal second.
Week Number

The Week Number reflects the fiscal week number. For example, if Fiscal year start is set to April, the week number for the date April 1, 2004 would be 1.

Weekday No change in behavior. The calendar weekday is the same as the fiscal weekday.
MM/YYYY No change in behavior. This date format always displays calendar dates, even when a fiscal year has been assigned.
M/D/Y This date format always displays Calendar dates, even when a fiscal year has been assigned.

The only date levels that explicitly indicate that the fiscal calendar is in use are the Year and Quarter level. Specifically, fiscal years and quarters are shown with the FY prefix. This is not true for fiscal months or week numbers, however, which are not shown with any special fiscal markings.

Fiscal year designations for any given date dimension are applied to all instances of the field in the Tableau workbook. Fiscal dates can only be applied to dimensions in a relational data source.

Fiscal year formatting is applied to all date formats that include a year, or a year and a quarter. In particular, if you apply a custom date format, and only use the “y” and “q” placeholders, then FY will be prepended to each year.

Date Truncations

When a date dimension is using a fiscal calendar, only the following date parts and truncations will reflect the fiscal calendar:

Date part or truncation When using a fiscal calendar
Year date part Fiscal year start is set to April, the year for the date June 1, 2004 would be shown as FY 2005.
Quarter date part Fiscal year start is set to April, the quarter for the date June 1, 2004 would be Q1.
Week Number date part Fiscal year start is set to April, the week number for the date April 1, 2004 would be 1.
Year date truncation Fiscal year start is set to May, the date June 1, 2004 would become May 1, 2004.
Quarter date truncation Fiscal year start is set to July, the date June 1, 2004 would become April 1, 2004.
Thanks for your feedback! There was an error submitting your feedback. Try again or send us a message.