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.
Friday to Thursday Week
Calendar
Date = CALENDAR(date(2014,01,01),date(2020,12,31))
Columns
Week Start date(Fri-Thu) = 'Date'[Date]+-1*if(WEEKDAY('Date'[Date])<6,WEEKDAY('Date'[Date])+1,WEEKDAY('Date'[Date])-6)
Week End date(Fri-Thu) = 'Date'[Week Start date(Fri-Thu)]+6
Year = Year([Date])
Weekday(Fri-Thu) = DATEDIFF([Week Start date(Fri-Thu)],[Date],DAY)+1
Week Year Start(Fri-Thu) = minx(filter('Date',[Year]=EARLIER([Year])),[Week Start date(Fri-Thu)])
Week of Year(Fri-Thu) = QUOTIENT(DATEDIFF([Week Year Start(Fri-Thu)],'Date'[Date],DAY),7)+1
Week = if('Date'[Week of Year(Fri-Thu)]<10,'Date'[Year]*10 & 'Date'[Week of Year(Fri-Thu)],'Date'[Year]&'Date'[Week of Year(Fri-Thu)])
Week Rank = RANKX(all('Date'),'Date'[Week Start date(Fri-Thu)],,ASC,Dense)
Week name = [Week Start date(Fri-Thu)] & " to "& [Week End date(Fri-Thu)]
eyJrIjoiYzNkNGM0YjQtMzNhNi00ZjhlLWI3MDAtOTg4ZTMyNzlmNDNlIiwidCI6ImVhOGJkMWZkLWFjMzQtNGFlMi1iNDIxLTZjZmEyZmNmZjI0MyJ9&pageName=ReportSection