Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combibing weekly data

Hi Team, I have bar chart which shows the user count for each week with respect to the month Is there any way I can combine the user  in the week 49 of November to week 49 of december amit...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , According to my you should month of week start date like

     

    Monday start

    Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

    Sunday start

    Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1

     

    Week = format([Week Start date ], "MMM") & "-W" & format( WEEKDAY([Date],2), "00") 

     

    // for Sunday use 1 on a weekday

     

    However, I agree with VahidDM , you can prefer to use week year 

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , According to my you should month of week start date like

 

Monday start

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

Sunday start

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],1)+1

 

Week = format([Week Start date ], "MMM") & "-W" & format( WEEKDAY([Date],2), "00") 

 

// for Sunday use 1 on a weekday

 

However, I agree with VahidDM , you can prefer to use week year