Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In short: I live in Europe and DAX/WEEKNUM does not give the same results als other Microsoft products like Outlook and the DAX/WEEKNUM logic is not according to the ISO 8601 calendar standard. Please change this.
Longer:
I live in Europe.
I use this formula in a DAX calulated date table:
The difference is that week 1 in DAX/WEEKNUM only has 3 days. And from after that week all numbers will be different from Outlook/the European ISO 8601 calendar standard, for the entire year.
This is documented here: https://docs.microsoft.com/en-us/dax/weeknum-function-dax
By default, the WEEKNUM function uses a calendar convention in which the week containing January 1 is considered to be the first week of the year. However, the ISO 8601 calendar standard, widely used in Europe, defines the first week as the one with the majority of days (four or more) falling in the new year. This means that for years in which there are three days or less in the first week of January, the WEEKNUM function returns week numbers that are different from the ISO 8601 definition.
So now with this behavior Power BI will differ from other Microsoft applications and also the European standard.
Why?
The only option I now see is making a custom date table but that has a lot of impact if I have to implement that in all our reports.
My suggestion is changing the DAX/WEEKNUM logic to match the logic in other Microsoft products like Outlook and thus the European standard.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.