WEEKNUM compatibility with ISO 8601

sql-bi / DaxDateTemplate

Power BI template to create a Date table in DAX

MIT License

265 stars 76 forks source link

WEEKNUM compatibility with ISO 8601 #50

Closed sfeldmannDE closed 3 years ago

sfeldmannDE commented 3 years ago

I'm using the DaxDate Template v.1.14 and I guess there is a problem with the week number. Related to ISO 8601 the first three days in January 2021 are week number 53 where as in the DaxDateTemplate the week number starts with 1.

WEEKNUM_v1-14

marcosqlbi commented 3 years ago

The ISO standard is implemented in FW prefixed columns. Check comments to properly setup parameters.