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
Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
✨️ November 12th-14th, 2024
Online Event
Register Here
