Overview

By default, the weeks in the Date table that ships with Cosmos start on Sunday. Your organization may want the week to start on a different day, such as Monday. This article will cover how to adjust the start date of weeks in the Date table.

Details

To adjust the Date table so that it starts on a day of the week other than Sunday there is just one line that needs to be added to the Date table script. 

At the top of the script that populates the Date table add the following text:

SET DATEFIRST X

X should be replaced with the number corresponding to the day of the week that you want the week to start on; the number 1 corresponds to Monday, for example, so to set the start of the week to be Monday this would be:

SET DATEFIRST 1

Details of this functionality along with this numbers correspond to which days are covered in the Microsoft article here:

SET DATEFIRST

Below is an example of what this would look like at the top of the Data table script:

Once the appropriate date is set, you will click Save and then click Publish Pipeline and then Run Pipeline for the changes to take effect.