Date.WeekOfMonth to start on Monday?

[dedelman_clng]

Is there a switch for the PowerQuery/M function Date.WeekOfMonth that will tell it that a week is Monday-Sunday instead of Sunday-Saturday?

I know I can do it with an IF statement based on the day of the week - just wondering if the function has the capability.

Thanks

David

[dedelman_clng]

Thanks @edhans - I initially didn't see the option come up in the editor. 

David

[edhans]

I've often seen parameters fail to show up until you hit the comma before that parameter, and if you don't know to look for it with a comma....

I wouldn't rely on Intellisense in PQ to help in the same way it does in DAX or in Excel. It isn't quite at that level.

[edhans · Accepted solution]

Yes, just change the start day parameter:

Date.WeekOfMonth(dateTime as any, optional firstDayOfWeek as nullable number) as nullable number  

Use Day.Monday for the FirstDayOfWeek parameter.

Many of the date functions, especially the Week functions, have this. They assume Day.Sunday I think, but you can easily change that to any day of the week.