Week of month starts on Monday - Calendar Table

[LucasCamargo]

Hello,

I created a table from CALENDAR function and now I am trying to create a "week of month" column starting om Monday (Mon - Sun).

I already have this code created: 

week of month =

var currentweek = WEEKNUM('Calendar'[Date],1)

var startweek = WEEKNUM(DATE('Calendar'[Date].[Year],'Calendar'[Date].[MonthNo],1),1)

return

Currentweek-startweek+1 

But I am not being able to set the starting day to Monday. Power BI sets automatically to format Sunday - Saturday

[Greg_Deckler · Accepted solution]

@LucasCamargo In your WEEKNUM function change the second parameter from 1 to 2.

[LucasCamargo]

I was trying to change to "2" only in one line, not both haha

Thank you very much Greg!