Calendar Returning Unusual Week Numbers

duncanwil 

You can use the right function (WEEKNUM) to extract the week number than the FORMAT function. Use the following calendar table code. it should work for you. 

Dates =
VAR StartYear = 2020
VAR EndYear = 2021
VAR DatesColumn =
   CALENDAR(
       DATE(StartYear , 1 , 1),
       DATE(EndYear, 12 , 31)
   )
RETURN
ADDCOLUMNS(
   DatesColumn,
   "Month No" , MONTH([Date]),
   "Month Name" , FORMAT( [Date] , "Mmmm" ),
   "Year" , YEAR([Date]),
   "Month Year No" , (YEAR([Date]) * 100) + MONTH([Date]),
   "Month Year" , FORMAT( [Date] , "Mmm yyyy"),
   "Quarter" , QUARTER([Date]),
   "Qtr Name" , FORMAT( [Date] , "\QQ"),
   "Week Day" , WEEKDAY([Date],2),
   "Week" , FORMAT( [Date] , "Dddd" ),
   "Week No" , WEEKNUM([Date],2),
   "Week Num" , "WK - " & WEEKNUM([Date],2) 
)