Hi, I have the following line in my date table. = Table.AddColumn(#“Inserted Week of Month”, “Start of Week”, each Date.StartOfWeek([Date],firstDayofWeek), type date) I want to change it to recognise Sunday as the first day of the week instead of Monday. Currently 30/8/20 is showing as week 35 an…

Hi @Hitman , Okay so I think I found something that works but you’ll have to do some checking over multiple years and/or changing start of week days. So without defining custom logic, we’ll rely the standard M function to calculate the Weeknumber. First Added a new WeekOfYear column with this logic…

M language - Start of week is Sunday not Monday

Power Query

Melissa July 23, 2020, 2:38pm 7

Hi @Hitman,

Okay so what qualifies as first week of the year??

Here’s an example for ISO week logic, can you provide something similar? Thanks