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
amitchandak
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
4 Replies
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 amitchandak VahidDM
Hi Anonymous
Try to use the column with Week Number, rather than Month+Week number then the output will be one column for week 49.
also, check this link: https://www.vahiddm.com/post/weekly-time-intelligence-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Thanks VahidDM for the input, but my end-user want to see the visual across month week
