Solved! Go to Solution.
The Formula is working but, 2021 is 1 week behind. Instead of showing WK07 it show WK06 - does it need to be change every year?
@amoshe2 the other solution posted here may work for your use case. The solution that ScottDrow gave me works for my use case where the first week of the year is that with Jan 1st regardless of the # of days of the new year in that week. I attempted to paste it below but for 2 days in a row now this page is giving me an "invalid HTML" error
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.