Forum Discussion
Solved
Calender table with Date.WeekOfYear = week 53
Hi all, I am struggeling with my Calender Table in Power Query editor. I have been using my Calender table for over a year now, but since the year 2021 my WeekOfYear is off. On the 1st of January...
Check this out
https://community.powerbi.com/t5/Desktop/Incorrect-week-number-at-year-end-beginning/m-p/1474033
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi Stefan,
I used
Week= WEEKNUM ('Date', 21)
It works for me.