Power query week number

You can add the optional week start parameter to your Date.WeekOfYear, like

Date.WeekOfYear([Date], Day.Monday)

--Nate

Hi IF,

let
    Source = #table(type table[Date=date], {{#date(2024,1,7)}}),
    #"Inserted Week of Year" = Table.AddColumn(Source, "Week of Year", each Date.WeekOfYear([Date], Day.Monday), Int64.Type),
    #"Inserted Day of Week" = Table.AddColumn(#"Inserted Week of Year", "Day of Week", each Date.DayOfWeek([Date], Day.Monday) +1, Int64.Type)
in
    #"Inserted Day of Week"