Week Number Sequence

[ajisharavind_99]

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 ??

[johnt75 · Accepted solution]

You can add a new column as

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

[johnt75 · Accepted solution]

You can add a new column as

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

[ajisharavind_99 · Accepted solution]

Excellent :), Thanks alot @johnt75