Forum Discussion

skitovich's avatar
skitovich
Helper I
6 years ago
Solved

Date problem

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 WEEK...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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

amitchandak's avatar
amitchandak
Super User
6 years ago

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