How to group the week number per month

[jchangco]

Hi Good Day,

How do I count the number of weeks in a month & concatenate it in the month name?

[FreemanZ]

or you do it in Power Query Editor like:

it worked like:

[FreemanZ]

hi @jchangco 

try to add a column like:

MonthWeek = FORMAT([Date], "MMM")&" - "&" Week "&(1 + WEEKNUM([Date]) - WEEKNUM(EOMONTH( [Date],-1 )))

it worked like:

[jchangco]

@FreemanZ ,

Thank you very much. I tried both the DAX & PowerQuery. It's working already.