custom weeknum

[Syndicate_Admin]

Hello I need your help.

how to create a custom weeknum column, starting on Thursday and ending on Wednesday; weeknum only has two criteria to start on Monday or Sunday.

[rsbin]

@Syndicate_Admin ,

Please review the documentation from Microsoft:

https://learn.microsoft.com/en-us/dax/weeknum-function-dax

It shows you the return_types to use for your particular case.

Trust this helps.

Regards,

[Syndicate_Admin · Accepted solution]

Thank you, I read the context of the function and found the solution, there he explains it well; return_type 14 is the solution.