Forum Discussion

rmcneish's avatar
rmcneish
Icon for Helper I rankHelper I
8 years ago
Solved

How 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...
Need Help
Show and Tell
  • rmcneish's avatar
    rmcneish
    8 years ago

    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)+1

     

    thanks.

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago

I'm recommending a single date table that includes the seasons. Its MUCH easier to work with. If you realy want the table of seasons you would add week numbers in your table with the range of dates or just have a measure to calcualte the week number and displaythat.  You can use the table as seasons but the measures are messier and if you use the date table with seasons approach PowerBI will do all the work for you and you don't need write measures in many cases and if you do they will be simple ones.

rmcneish's avatar
rmcneish
Icon for Helper I rankHelper I
8 years ago

i would like that!.

 

I have been working with data since 2001. it's too much.