Question Details

No question body available.

Tags

powerquery

Answers (1)

January 14, 2026 Score: 0 Rep: 13,452 Quality: Low Completeness: 50%

Just take the start of the week Date.StartOfWeek([Spalte1]) as base for months name calculation Date.MonthName:

let
    Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
    #"DateType" = Table.TransformColumnTypes(Source,{{"Spalte1", type datetime}}),
    #"CustomMonth" = Table.AddColumn(#"DateType", "Custom Month", each  Date.MonthName(Date.StartOfWeek([Spalte1],1))),
    #"TrueMonth" = Table.AddColumn(#"CustomMonth", "True Month", each Date.MonthName([Spalte1]), type text)
in
    #"TrueMonth"