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
I can give you the formules for week 53 at the beginning of 2021.
But then we have a other problem:
If you select year & week, 1 January 2021 falls in week 53-2021.
That is incorrect.
Does someone know a solution for this?
Hi vdE ,
I haven't thought of that. I always use my Week No. and Year columns seperate from each other. I also do not have a solution for your challenge.
