Forum Discussion

ajisharavind_99's avatar
ajisharavind_99
Advocate I
4 years ago
Solved

Week Number Sequence

Hi, 

I have dynamic Calendar Table starting from 07-Sep-2021 to 31-Jan-2023, I m looking for week number in sequence 1 to 73 (sample below). Any solution ??

 

 

Need Help

2 Replies

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    You can add a new column as

    Week num = QUOTIENT( 'Table'[Date] - DATE(2021, 9, 7), 7) + 1