Week of month from Calendar

[RMV]

Hi,

I created a new table and apply calendar formula to generate date:

CALENDAR(DATE(2017,01,01),DATE(2017,12,31))

Is there any function to show the Week of Month using dax language?

What I mean by Week of Month is for example: 1 Jun 2017 is considered as Week 1 (in month of June)

Regards,

[Anonymous · Accepted solution]

Hi @RMV,

You can simple add a calculated column to calculate the week of month: (use current week number -  month start week number)

Week of Month = 
var currentweek=WEEKNUM([Date],1)
var startWeek=WEEKNUM(DATE([Date].[Year],[Date].[MonthNo],1),1)
return
Currentweek-startWeek+1

Regards,

Xiaoxin Sheng

[RMV]

It works! Thanks, @Anonymous!