topic Re: Combibing weekly data in DAX Commands and Tips

Combibing weekly data

Anonymous — Mon, 10 Jan 2022 02:10:05 GMT

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

Re: Combibing weekly data

VahidDM — Mon, 10 Jan 2022 03:02:14 GMT

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/

Re: Combibing weekly data

Anonymous — Mon, 10 Jan 2022 03:22:15 GMT

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

Re: Combibing weekly data

amitchandak — Mon, 10 Jan 2022 08:42:18 GMT

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

Re: Combibing weekly data

Anonymous — Mon, 10 Jan 2022 10:14:50 GMT

Thanks amitchandak VahidDM