Set Firstweekday as first day of the year

[pindelicato]

We have an app where every year we want to set the Firstweekday to be the day of the week on Jan 1.

Is this possible to do dynamically in the load script?

Can this be written to look at Day of Week for First day of year?

SET FirstWeekDay=4;

Alternatively could I move the setting of this to after I load data and then load a column from my table so it would be

SET FirstWeekDay=[FirstdayofYearNumber]; ?

Where I would just have my calendar in my data tables set the first dayofYear number to match the needed Number for QS to ingest and appropriately set the first day of week to whatever we need?

[Anil_Babu_Samineni]

You can break in to the field such away how variable stored and then you can use new variable if needed somewhere rather touching predefined variables.