Forum Discussion
ajisharavind_99
Advocate I
Advocate IWeek 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 ??
You can add a new column as
Week num = QUOTIENT( 'Table'[Date] - DATE(2021, 9, 7), 7) + 1Excellent :), Thanks alot johnt75
2 Replies
johnt75Super User
You can add a new column as
Week num = QUOTIENT( 'Table'[Date] - DATE(2021, 9, 7), 7) + 1- ajisharavind_99
Excellent :), Thanks alot johnt75