How to fix Date.WeekOfYear behavior?

Power Query
6

Thank you @Melissa , I like the short, clean style of your solution! Sorry for the late response, but I was busy with a Shapemap problem I’ll post about later.
BR
Martin