How to fix Date.WeekOfYear behavior?

Power Query
3

Power Query: Date.WeekOfYear( dateTime as any, optional firstDayOfWeek)
i.e. : Date.WeekOfYear(#date(2011, 03, 27), Day.Monday) Returns 13.
Date.WeekOfYear(#date(2011, 03, 27)) Returns 14.

1 Like