Forum Discussion
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...
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
Thanks VahidDM for the input, but my end-user want to see the visual across month week