Forum Discussion

jcpewittyancey's avatar
jcpewittyancey
Helper I
7 years ago
Solved

Creating a custom Week Number variable in a date table

Hi all. I need to create a Week Number column in a date table, but the WEEKNUM function doesn't produce quite the right results.   For the purposes of this variable, weeks start on Sunday. The part...
Need Help
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    try adding a calculated column with this formula

     

    =WEEKNUM( [Date] + 1, 21 )
  • AlB's avatar
    AlB
    5 years ago

    Anonymous 

    This will answer your question:

    https://dax.guide/weeknum/

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

LivioLanzo's avatar
LivioLanzo
Solution Sage
7 years ago

try adding a calculated column with this formula

 

=WEEKNUM( [Date] + 1, 21 )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi LivioLanzo ,

 

Thanks for the solution, this has helped me as well.

I would like to know the logic behind 21, as i could see while typing the formula, we have the option of only 1 (sunday) and 2(Monday).

 

Thanks in advance.

 

Regards,

Pavan