Date problem

[skitovich]

Hello everyone. There was such a problem. I count data by week. Data is counted from Sunday to Saturday. How do I make the data count from Monday to Sunday?
I create a column of weeks using the WEEKNUM function.
Thanks for the help

[amitchandak · Accepted solution]

WEEKNUM([Date],2) for monday

WEEKDAY('Date'[Date],2) for Weekday one as Monday

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Number = WEEKNUM([Date],2)
Week = if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
Week name = [Week Start date] & " to "& [Week End date]

Also, refer file

https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0