DATEPART Returns Week Value of 53 Instead of 1

Issue

When the data source includes a week that spans the end of one year and the beginning of another, for example if Sunday through Thursday occur in 2013 and Friday through Saturday occur in 2014, the DATEPART function for week and year returns a value of 53 instead of 1.

Environment

Tableau Desktop

Resolution

Create two calculated fields to use in place of date fields for Week and Year:

Select Analysis > Create Calculated Field to create the calculated field for week.
In the Calculated Field dialog box that opens, type a name for the field. For example, Week Field.
In the Formula box, type the following formula:
If datepart('week',[Date])=53 then 1 else datepart('week',[Date]) end
and then click OK.
Select Analysis > Create Calculated Field to create the calculated field for year.
In the Calculated Field dialog box that opens, type a name for the field. For example, Year Field.
In the Formula box, type the following formula:
If datepart('week',[Date])=53 then datepart('year',[Date])+1 else datepart('year',[Date]) end
and then click OK.
Right-click Week Field in Measures and select Convert to Dimension. Repeat for Year Field.
Use the new calculated fields in the view in place of the Week and Year date fields

Cause

To allow for more flexibility in how weeks are defined, Tableau Desktop calculates the week number based on the week start day, set at the data source level, within each year.

For some European locales, the date can be formatted to display using the ISO 8601 standard. See Using Week-Based Placeholders in Custom Date Formats for directions.

Additional Information

To voice your support for the inclusion of this feature in a future product release, add your vote to the ISO8601 WeekDate rules applied in Tableau idea on the Community Forum.
Clearly and Simply: Week in, week out, Tableau