Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Thursday to Wednesday Week
Calendar
Date = CALENDAR(date(2014,01,01),date(2020,12,31))
Columns
Year = Year([Date])
Week Start date(Thu-Wed) = 'Date'[Date]+-1*if(WEEKDAY('Date'[Date])<5,WEEKDAY('Date'[Date])+2,WEEKDAY('Date'[Date])-5)
Week End date(Thu-Wed) = 'Date'[Week Start date(Thu-Wed)]+6
Weekday(Thu-Wed) = DATEDIFF([Week Start date(Thu-Wed)],[Date],DAY)+1
Week = if('Date'[Week of Year(Thu-Wed)]<10,'Date'[Year]*10 & 'Date'[Week of Year(Thu-Wed)],'Date'[Year]&'Date'[Week of Year(Thu-Wed)])
Week Year Start(Thu-Wed) = minx(filter('Date',[Year]=EARLIER([Year])),[Week Start date(Thu-Wed)])
Week of Year(Thu-Wed) = QUOTIENT(DATEDIFF([Week Year Start(Thu-Wed)],'Date'[Date],DAY),7)+1
Week Rank = RANKX(all('Date'),'Date'[Week Start date(Thu-Wed)],,ASC,Dense)
Week name = [Week Start date(Thu-Wed)] & " to "& [Week End date(Thu-Wed)]
eyJrIjoiM2UzMzIzMGYtM2I1OS00NGY0LWE2ZGYtZmYwOGZhNGU4NGU2IiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9