Forum Discussion
Weeknr - wrong week
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)
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.
3 Replies
bilingual , with option two, First week start with year start.
Check Are looking for ISO week ?
Iso Week = weenum([date],21)
Hi Amit, thanks a lot, can i do it directly in Query editor with M coding?
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.
