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
  • johnt75's avatar
    johnt75
    4 years ago

    You can add a new column as

    Week num = QUOTIENT( 'Table'[Date] - DATE(2021, 9, 7), 7) + 1
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
ajisharavind_99's avatar
ajisharavind_99
Advocate I
4 years ago

Excellent :), Thanks alot johnt75