Forum Discussion
rmcneish
Helper I
Helper IHow to create a custom week number by date'
Dear super users. I need to create a column with week number according to a date range since "START" to "END". TY for your support. Regards. Vvelarde disculpa por etiquetarte pero en el...
I got it !!
#week = var datestart = MAXX(FILTER(TEMPORADAS,TEMPORADAS[INICIO]<='E+R+N'[F. PROD]&&TEMPORADAS[FIN]>'E+R+N'[F. PROD]),TEMPORADAS[INICIO]) return DATEDIFF(datestart,'E+R+N'[F. PROD],WEEK)+1thanks.
MauriceMecowe
Resolver II
Resolver II= WEEKNUM([Start],1) 1 in this case is Sunday. If you want Monday use 2 etc.
rmcneish