Forum Discussion

New_be's avatar
New_be
Icon for Helper V rankHelper V
2 years ago

Calendar: Create column that that shows 6 weeks from current week

Hi Expert, General: I failed to create a week column that plus 6 week from current week. Especially when it involves different year.   Question: Now is Year 23 and week 52 for me. So, current ...
Need Help
Show and Tell
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

HI, New_be 

try below code for column
just adjust column and table name

 

Column = 
var curr_year = YEAR(calender[Date])
var nutoincrease = 6
var yearweek = CONVERT((RIGHT(YEAR(calender[Date]),2)*100 +WEEKNUM(calender[Date]))+nutoincrease,INTEGER)
var maxweek = WEEKNUM(DATE(curr_year,12,31))
var next = CONVERT((RIGHT(YEAR(calender[Date]),2)+1)*100,INTEGER)  +nutoincrease
return
IF(WEEKNUM(calender[Date])=maxweek,next,yearweek)