Hello Sisense Community,I would like to change Start of Week on "WEEKOFYEAR" function to Friday from default Monday at the column level (not at general server config settings).Is there a standard formula available? Thanks, - Dennis

Hey Dennis_M , As the "WEEKOFYEAR" Started on Monday you can add additional function of ADDDAYS to consider Friday's only within the "WEEKOFYEAR" formula. In the current approach, weekofyear(dd.[Date]) starts from Monday. Instead, by using the ADDDAYS function, the formula is modified to: weekofyear(adddays(dd.[Date], -4)), shifting the week start to Friday. See Example: Created Dim Date (Using the Built it Custom Code for 2025 year) Created additional Custom Table with the Below Synta...

WEEKOFYEAR Function - Change Start of Week to Friday from Monday at Calculated Col Level | Help and How-To

MoreDiscussions

WEEKOFYEAR Function - Change Start of Week to Friday from Monday at Calculated Col Level | Help and How-To | Sisense Community