KNOWLEDGE BASE

Function Week() Is Not Working Properly When Changing The Start Weekday Of The Week.


Published: 20 Jul 2020
Last Modified Date: 10 Nov 2020

Issue

Function Week() Is Not Working Properly When Changing The Start Weekday Of The Week.

Environment

  • Tableau Desktop

Resolution

Use DATEPART('WEEK',[DATE]) instead.

Cause

Function WEEK() will always calculate the start of a week with Sunday no matter whether you change the start of the week or not.
This is as designed.
Did this article resolve the issue?