Weeknr - wrong week

[bilingual]

Hi, I made a calender table and everything worked fine, but now i see that my WEEKNR is not working correctly, the weeknr for the dates 15-21 of february is registrered as week 8, instead of Week 7. 

I use a calendar table , but even when i create WEEKNR directly in the Data table it still registers as Week 8, anybody know why? - i use the formunla Weeknr([Date],2)

[amitchandak]

@bilingual , with option two, First week start with year start.

Check Are looking for ISO week ?

Iso Week = weenum([date],21)

[bilingual]

Hi Amit, thanks a lot, can i do it directly in Query editor with M coding?

[v-jingzhang · Accepted solution]

@bilingual 

There is no native ISO Week function in M language. However, you can create ISO week column with some M codes. Below are some blogs about this:

Power Query (M) - Iso Week (ISO 8601) : excel (reddit.com)

How to calculate ISO week number in Power Query - Data Cornering

Regards,
Community Support Team _ Jing Zhang
If this post helps, please Accept it as the solution to help other members find it.