Weeknumber is wrong

[TechR21]

Hi,

I have the following table":

Now iI created a column to have the weeknumbers

but when i look, the numbers are matching but the numbers of the week are off. as you can see these two records are created in week 45, and not 46.

What am i missing here?

[djurecic]

Hi @TechR21 ,

 This article might be helpful to you. Weeknum accepts a parameter than can change the output.

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

Please consider accepting as solution if this has answered the question.

[PaulDBrown · Accepted solution]

WEEKNUM has an optional return type which establishes when the week begins (day of week and week of year):

WEEKNUM ( <Date> [, <ReturnType>] )

See here for further detail:

https://dax.guide/weeknum/