Combibing weekly data

[Anonymous]

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 

[amitchandak · Accepted solution]

@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 

[Anonymous]

Thanks @amitchandak @VahidDM 

[Anonymous]

Thanks @VahidDM  for the input, but my end-user want to see the visual across month week

[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/