Assign Week Number to a Single Month Across Multiple Years

Hi  , tl1234 

My recommended approache is instead of relying on month and week columns from your fact tables, create a Date Dimension with:

let
    StartDate = #date(2022, 1, 1),
    EndDate = #date(2025, 12, 31),
    Dates = List.Dates(StartDate, Duration.Days(EndDate - StartDate)+1, #duration(1,0,0,0)),
    Table = Table.FromList(Dates, Splitter.SplitByNothing(), {"Date"}),
    AddColumns = Table.TransformColumns(Table, {{"Date", type date}}),
    AddYear = Table.AddColumn(AddColumns, "Year", each Date.Year([Date])),
    AddMonth = Table.AddColumn(AddYear, "Month", each Date.Month([Date])),
    AddMonthName = Table.AddColumn(AddMonth, "Month Name", each Date.MonthName([Date])),
    AddWeek = Table.AddColumn(AddMonthName, "Week Number", each Date.WeekOfYear([Date]))
in 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.