Dyota's blog

Power Query: Months

This make a table with all the month numbers and names.

let
    numbers = {1..12},

    today = DateTime.LocalNow(),

    months = List.Transform(
        numbers, 
        each Date.MonthName(#date(2000, _, 1))
    ),

    abb = List.Transform(
        months, 
        each Text.Start(_, 3)
    ),

    combined = Table.FromColumns({
        numbers,
        months, 
        abb
    }, {"Month Number", "Month", "Abbreviation"})
in
    combined

#powerquery