combine the week number to one month

[Anonymous]

the graph shows the count of users registered in each week, since week 13 is in month of april and march my count get distributed. is there any way that i combine the data to one month. or instead can we  show month with only 4 or 5 weeks( example march 1st week, march 2nd week...march 5th week)

[Anonymous]

It worked for me!, Thanks a lot!

[amitchandak]

@Anonymous , You can create a month week column in your date table and use it

Start Month = STARTOMONTH('Date'[Date]) // or use // eomonth([Date],-1)+1
WeekDay = WEEKDAY([Date],2) //monday
Start of Week = [Date] -[WeekDay]+1 //monday
Month Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[Start Month]=EARLIER([Start Month])),'Date'[Start of Week]),[Date],DAY),7)+1