// Ultimate Calendar Table, v2.06
// downloaded from the www.powerquery.sk website
let
    startYear = 2020,
    endYear = 2024,  // use Date.Year(DateTime.FixedLocalNow()) for current year
    language = "en-US",    // US English = en-US, German = de-DE, Austrian German = de-AT, Slovak = sk-SK, Czech = cs-CZ
    columnNamesWithoutDiacritics = false,   // enter "true", if you want the columns without diacritics (for easier writing of DAX formulas)
    fiscalYearStartMonth = 3,
    fiscalYearPrefix = "FY",
    semesterPrefix = "H",
    quarterPrefix = "Q",
    monthPrefix = "M",
    weekPrefix = "W",
    firstDayOfWeek = Day.Monday,

    startDate = #date(startYear, 1, 1),
    endDate = #date(endYear, 12, 31), 
    timespanDuration = Duration.Days(Duration.From(endDate - startDate)) + 1,
    yesNo = if language = "en-US" then {"yes", "no"} else if language = "de-DE" or language = "de-AT" then {"ja", "nein"} else if language = "sk-SK" then {"áno", "nie"} else if language = "cs-CZ" then {"ano", "ne"} else {"xxx", "xxx"}, 
    decade = if language = "en-US" then "decade" else if language = "de-DE" or language = "de-AT" then "Dekade" else if language = "sk-SK" then "dekáda" else if language = "cs-CZ" then "dekáda" else {"xxx", "xxx"},
    orderNames = if language = "en-US" then [1 = "1st", 2 = "2nd", 3 = "3rd"] else [1 = "1.", 2 = "2.", 3 = "3."],
    isSupportedLanguage = List.Contains({"sk-SK", "cs-CZ", "en-US", "de-DE", "de-AT"}, language),
    currentDateTime = DateTime.FixedLocalNow(),

    fxISOCalendarWeek = (Data as date) as number =>
        let
            Weekday = Date.DayOfWeek(Data) + 1,
            Part1 = Number.From(Data) - Weekday + 11,
            Part2 = Number.From(#date(Date.Year(Date.From(Number.From(Data) + 4 - Weekday)),1,1)),
            Part3 = (Part1 - Part2) / 7,
            Tranc = Part3 - Number.Mod(Part3, 1)
        in
            Tranc,
    fxISOCalendarYear = (Data as date) as number =>
        Date.Year(Date.AddDays(Data, 26 - fxISOCalendarWeek(Data))),
        
    Source = if isSupportedLanguage then List.Dates(startDate, timespanDuration, #duration(1, 0, 0, 0)) else error [Message = "Nie je možné vygenerovať časovú tabuľku.", Detail ="Nepodporovaný jazyk"],
    #"Converted To Table" = Table.FromList(Source, Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted To Table",{{"Date", type date}}),
    #"Inserted Date ID" = Table.AddColumn(#"Changed Type", "Date ID", each Date.Year([Date]) * 10000 + Date.Month([Date]) * 100 + Date.Day([Date]), Int64.Type),
    InsertedYear = Table.AddColumn(#"Inserted Date ID", "Year", each Date.Year([Date]), Int64.Type),
    InsertedSemester = Table.AddColumn(InsertedYear, "Semester", each if Date.Month([Date]) < 7 then 1 else 2, Int64.Type),
    #"Inserted Year-Semester" = Table.AddColumn(InsertedSemester, "Year-Semester", each Text.From([Year]) & "-" & semesterPrefix & Text.From([Semester]), type text),
    #"Inserted Quarter" = Table.AddColumn(#"Inserted Year-Semester", "Quarter", each Date.QuarterOfYear([Date]), Int64.Type),
    #"Inserted Year-Quarter" = Table.AddColumn(#"Inserted Quarter", "Year-Quarter", each Text.From([Year]) & "-" & quarterPrefix & Text.From([Quarter]), type text),
    #"Inserted Month" = Table.AddColumn(#"Inserted Year-Quarter", "Month", each Date.Month([Date]), Int64.Type),
    #"Inserted Year-Month" = Table.AddColumn(#"Inserted Month", "Year-Month", each Text.From([Year]) & "-" & Text.PadStart(Text.From([Month]), 2, "0"), type text),
    #"Inserted Day of Month" = Table.AddColumn(#"Inserted Year-Month", "Day", each Date.Day([Date]), Int64.Type),
    #"Inserted Week of Year" = Table.AddColumn(#"Inserted Day of Month", "Week", each Date.WeekOfYear([Date], firstDayOfWeek), Int64.Type),
    #"Inserted ISO Week" = Table.AddColumn(#"Inserted Week of Year", "Week ISO", each fxISOCalendarWeek([Date]), Int64.Type),
    #"Inserted ISO Year" = Table.AddColumn(#"Inserted ISO Week", "Year ISO", each fxISOCalendarYear([Date])),
    #"Inserted Year-Week" = Table.AddColumn(#"Inserted ISO Year", "Year-Week", each Text.From([Year]) & "-" & weekPrefix & Text.PadStart(Text.From([Week]), 2, "0")),
    #"Inserted Year-Week ISO" = Table.Buffer(Table.AddColumn(#"Inserted Year-Week", "Year-Week ISO", each Text.From([Year ISO]) & "-" & weekPrefix & Text.PadStart(Text.From([Week ISO]), 2, "0"))),
    #"Number Of Weeks In Previous Years" = (columns as list) as table =>
                let
                    Source = #"Inserted Year-Week ISO",
                    #"Removed Other Columns" = Table.SelectColumns(Source, columns),
                    #"Grouped Rows" = Table.Buffer(Table.Sort(Table.Group(#"Removed Other Columns", {columns{0}}, {{"Max Week", each List.Max(Table.Column(_, columns{1})), type number}}), {columns{0}, Order.Ascending})),
                    Indexed = Table.AddIndexColumn(#"Grouped Rows", "Index", 1, 1),
                    #"Added Custom" = Table.AddColumn(Indexed, "Number of Weeks in Previous Years", each List.Sum(List.Range(Indexed[Max Week], 0, [Index] - 1)), Int64.Type),
                    result = Table.ReplaceValue(#"Added Custom", null, 0, Replacer.ReplaceValue, {"Number of Weeks in Previous Years"})
                in
                    result,
    groupedYearsWeeks = Table.Buffer(#"Number Of Weeks In Previous Years"({"Year", "Week"})),
    #"Inserted Number Of Weeks In Previous Years" = Table.AddColumn(#"Inserted Year-Week ISO", "Number of Weeks in Previous Years", each Table.SelectRows(groupedYearsWeeks, (PTPR) => [Year] = PTPR[Year])[Number of Weeks in Previous Years]{0}),
    #"Inserted Week Sequence Number" = Table.AddColumn(#"Inserted Number Of Weeks In Previous Years", "Week Sequence Number", each [Number of Weeks in Previous Years] + [Week]),
    groupedYearsWeeksISO = Table.Buffer(#"Number Of Weeks In Previous Years"({"Year ISO", "Week ISO"})),
    #"Inserted Number Of ISO Weeks In Previous Years" = Table.AddColumn(#"Inserted Week Sequence Number", "Number of ISO Weeks in Previous Years", each Table.SelectRows(groupedYearsWeeksISO, (PTPR) => [Year ISO] = PTPR[Year ISO])[Number of Weeks in Previous Years]{0}),
    #"Inserted ISO Week Sequence Number" = Table.AddColumn(#"Inserted Number Of ISO Weeks In Previous Years", "ISO Week Sequence Number", each [Number of ISO Weeks in Previous Years] + [Week ISO]),
    #"Inserted Start Of Year" = Table.AddColumn(#"Inserted ISO Week Sequence Number", "Start of Year", each Date.StartOfYear([Date]), type date),
    #"Inserted End Of Year" = Table.AddColumn(#"Inserted Start Of Year", "End of Year", each Date.EndOfYear([Date]), type date),
    #"Inserted Start Of Quarter" = Table.AddColumn(#"Inserted End Of Year", "Start of Quarter", each Date.StartOfQuarter([Date]), type date),
    #"Inserted End of Quarter" = Table.AddColumn(#"Inserted Start Of Quarter", "End Of Quarter", each Date.EndOfQuarter([Date]), type date),
    #"Inserted Start Of Month" = Table.AddColumn(#"Inserted End of Quarter", "Start of Month", each Date.StartOfMonth([Date]), type date),
    #"Inserted End Of Month" = Table.AddColumn(#"Inserted Start Of Month", "End of Month", each Date.EndOfMonth([Date]), type date),
    #"Inserted Month Name" = Table.AddColumn(#"Inserted End Of Month", "Month Name", each Date.MonthName([Date], language), type text),
    #"Inserted Number Of Days In Month" = Table.AddColumn(#"Inserted Month Name", "Days in Month", each Date.DaysInMonth([Date]), Int64.Type),
    #"Inserted Start Of Week" = Table.AddColumn(#"Inserted Number Of Days In Month", "Start of Week", each Date.StartOfWeek([Date], firstDayOfWeek), type date),
    #"Inserted End Of Week" = Table.AddColumn(#"Inserted Start Of Week", "End of Week", each Date.EndOfWeek([Date], firstDayOfWeek), type date),
    #"Inserted Week Of Month" = Table.AddColumn(#"Inserted End Of Week", "Week of Month", each Date.WeekOfMonth([Date], firstDayOfWeek), Int64.Type),
    #"Inserted Day of Week" = Table.AddColumn(#"Inserted Week Of Month", "Day of Week", each Date.DayOfWeek([Date], firstDayOfWeek) + 1, Int64.Type),
    #"Inserted Day of Year" = Table.AddColumn(#"Inserted Day of Week", "Day of Year", each Date.DayOfYear([Date]), Int64.Type),
    #"Inserted Day Name" = Table.AddColumn(#"Inserted Day of Year", "Day Name", each Date.DayOfWeekName([Date], language), type text),
    #"Inserted Weekend" = Table.AddColumn(#"Inserted Day Name", "Weekend", each if [Day of Week] >= 6 then yesNo{0} else yesNo{1}, type text),
    #"Inserted Leap Year" = Table.AddColumn(#"Inserted Weekend", "Is Leap Year", each if Date.IsLeapYear([Date]) then yesNo{0} else yesNo{1}, type text),
    #"Inserted UNIX timestamp" = Table.AddColumn(#"Inserted Leap Year", "UNIX timestamp", each Duration.TotalSeconds(DateTime.From([Date]) - #datetime(1970, 1, 1, 0, 0, 0)), Int64.Type),
    #"Inserted Fiscal Year" = Table.AddColumn(#"Inserted UNIX timestamp", "Fiscal Year", each if [Date] < #date(Date.Year([Date]), fiscalYearStartMonth, 1) then [Year] else [Year] + 1, Int64.Type),
    #"Inserted Fiscal Month" = Table.AddColumn(#"Inserted Fiscal Year", "Fiscal Month", each Number.Mod([Month] + 12 - fiscalYearStartMonth, 12) + 1, Int64.Type),
    #"Inserted Fiscal Quarter" = Table.AddColumn(#"Inserted Fiscal Month", "Fiscal Quarter", each Number.RoundDown(([Fiscal Month] - 1) / 3) + 1, Int64.Type),
    #"Inserted Fiscal Semester" = Table.AddColumn(#"Inserted Fiscal Quarter", "Fiscal Semester", each Number.RoundDown(([Fiscal Quarter] - 1) / 2, 0) + 1, Int64.Type),
    #"Inserted Fiscal Year Report" = Table.AddColumn(#"Inserted Fiscal Semester", "Fiscal Year Report", each fiscalYearPrefix & Text.From([Fiscal Year])),
    #"Inserted Fiscal Year Turn Of" = Table.AddColumn(#"Inserted Fiscal Year Report", "Fiscal Year Turn Of", each fiscalYearPrefix & Text.From([Fiscal Year]) & "/" & Text.From([Fiscal Year] + 1)),
    #"Inserted Fiscal Year Turn Of Short" = Table.AddColumn(#"Inserted Fiscal Year Turn Of", "Fiscal Year Turn Of Short", each fiscalYearPrefix & Number.ToText([Fiscal Year] - 2000, "D2") & "/" & Number.ToText([Fiscal Year] + 1 - 2000, "D2")),
    #"Inserted Fiscal Semester Report" = Table.AddColumn(#"Inserted Fiscal Year Turn Of Short", "Fiscal Semester Report", each fiscalYearPrefix & Text.From([Fiscal Year]) & "-" & semesterPrefix & Text.From([Fiscal Semester])),
    #"Inserted Fiscal Quarter Report" = Table.AddColumn(#"Inserted Fiscal Semester Report", "Fiscal Quarter Report", each fiscalYearPrefix & Text.From([Fiscal Year]) & "-" & quarterPrefix & Text.From([Fiscal Quarter])),
    #"Inserted Fiscal Month Report" = Table.AddColumn(#"Inserted Fiscal Quarter Report", "Fiscal Month Report", each fiscalYearPrefix & Text.From([Fiscal Year]) & "-" & monthPrefix & Text.PadStart(Text.From([Fiscal Month]), 2, "0")),
    #"Inserted Is Current Date" = Table.AddColumn(#"Inserted Fiscal Month Report", "Is Current Date", each if [Date] = Date.From(currentDateTime) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current Week" = Table.AddColumn(#"Inserted Is Current Date", "Is Current Week", each if [Week] = Date.WeekOfYear(currentDateTime, firstDayOfWeek) and [Year] = Date.Year(currentDateTime) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current ISO Week" = Table.AddColumn(#"Inserted Is Current Week", "Is Current ISO Week", each if [Week ISO] = fxISOCalendarWeek(Date.From(currentDateTime)) and [Year ISO] = fxISOCalendarYear(Date.From(currentDateTime)) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current ISO Year" = Table.AddColumn(#"Inserted Is Current ISO Week", "Is Current ISO Year", each if [Year ISO] = fxISOCalendarYear(Date.From(currentDateTime)) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current Month" = Table.AddColumn(#"Inserted Is Current ISO Year", "Is Current Month", each if [Month] = Date.Month(currentDateTime) and [Year] = Date.Year(currentDateTime) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current Quarter" = Table.AddColumn(#"Inserted Is Current Month", "Is Current Quarter", each if [Quarter] = Date.QuarterOfYear(currentDateTime) and [Year] = Date.Year(currentDateTime) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current Semester" = Table.AddColumn(#"Inserted Is Current Quarter", "Is Current Semester", each if [Semester] = Number.IntegerDivide(Date.Month(currentDateTime) - 1, 6) + 1 and [Year] = Date.Year(currentDateTime) then yesNo{0} else yesNo{1}),
    #"Inserted Is Current Year" = Table.AddColumn(#"Inserted Is Current Semester", "Is Current Year", each if [Year] = Date.Year(currentDateTime) then yesNo{0} else yesNo{1}),
    #"Inserted Semester Sequence Number" = Table.AddColumn(#"Inserted Is Current Year", "Semester Sequence Number", each ([Year] - startYear) * 2 + [Semester]),
    #"Inserted Quarter Sequence Number" = Table.AddColumn(#"Inserted Semester Sequence Number", "Quarter Sequence Number", each ([Year] - startYear) * 4 + [Quarter]),
    #"Inserted Month Sequence Number" = Table.AddColumn(#"Inserted Quarter Sequence Number", "Month Sequence Number", each ([Year] - startYear) * 12 + [Month]),
    #"Inserted Decade of Month" = Table.AddColumn(#"Inserted Month Sequence Number", "Decade of Month", each if [Day] <= 10 then 1 else if [Day] <= 20 then 2 else 3),
    #"Inserted Decade of Month Name" = Table.AddColumn(#"Inserted Decade of Month", "Decade of Month Name", each Record.Field(orderNames, Text.From([Decade of Month])) & " " & decade),
    #"Reordered Columns" = Table.ReorderColumns(#"Inserted Decade of Month Name",{"Date", "Date ID", "Year", "Year ISO", "Semester", "Year-Semester", "Semester Sequence Number", "Quarter", "Year-Quarter", "Quarter Sequence Number", "Month", "Year-Month", "Month Name", "Month Sequence Number", "Decade of Month", "Decade of Month Name", "Day", "Day of Week", "Day Name", "Week", "Year-Week", "Number of Weeks in Previous Years", "Week Sequence Number", "Week ISO", "Year-Week ISO", "Number of ISO Weeks in Previous Years", "ISO Week Sequence Number", "Start of Year", "End of Year", "Start of Quarter", "End Of Quarter", "Start of Month", "End of Month", "Start of Week", "End of Week", "Days in Month", "Week of Month", "Day of Year", "Weekend", "Is Leap Year", "UNIX timestamp", "Fiscal Year", "Fiscal Semester", "Fiscal Quarter", "Fiscal Month", "Fiscal Year Report", "Fiscal Year Turn Of", "Fiscal Year Turn Of Short", "Fiscal Semester Report", "Fiscal Quarter Report", "Fiscal Month Report", "Is Current Date", "Is Current Week", "Is Current ISO Week", "Is Current Month", "Is Current Quarter", "Is Current Semester", "Is Current Year", "Is Current ISO Year"}),
    #"Added Index" = Table.AddIndexColumn(#"Reordered Columns", "Index", 1, 1),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Index",{{"Index", Int64.Type}, {"Fiscal Year Report", type text}, {"Fiscal Year Turn Of", type text}, {"Fiscal Year Turn Of Short", type text}, {"Fiscal Semester Report", type text}, {"Fiscal Quarter Report", type text}, {"Fiscal Month Report", type text}, {"Year ISO", Int64.Type}, {"Year-Week ISO", type text}, {"Year-Week", type text}, {"Number of Weeks in Previous Years", Int64.Type}, {"Week Sequence Number", Int64.Type}, {"Number of ISO Weeks in Previous Years", Int64.Type}, {"ISO Week Sequence Number", Int64.Type}, {"Is Current Date", type text}, {"Semester Sequence Number", Int64.Type}, {"Quarter Sequence Number", Int64.Type}, {"Month Sequence Number", Int64.Type}, {"Decade of Month", Int64.Type}, {"Decade of Month Name", type text}, {"Is Current Month", type text}, {"Is Current Quarter", type text}, {"Is Current Semester", type text}, {"Is Current Year", type text}, {"Is Current Week", type text}, {"Is Current ISO Week", type text}, {"Is Current ISO Year", type text}}),
    columnNamesSK = { "Dátum", "ID dátumu", "Rok", "Rok ISO", "Polrok", "Štvrťrok", "Mesiac", "Názov mesiaca", "Deň", "Deň v týždni", "Názov dňa", "Týždeň", "Týždeň ISO", "Rok-Týždeň", "Rok-Týždeň ISO", "Počet týždňov v predchádzajúcich rokoch", "Poradové číslo týždňa od začiatku", "Počet ISO týždňov v predchádzajúcich rokoch", "Poradové číslo ISO týždňa od začiatku", "Začiatok roka", "Koniec roka", "Začiatok štvrťroka", "Koniec štvrťroka", "Začiatok mesiaca", "Koniec mesiaca", "Začiatok týždňa", "Koniec týždňa", "Dni v mesiaci", "Týždeň v mesiaci", "Deň v roku", "Prestupný rok", "Fiškálny rok", "Fiškálny polrok", "Fiškálny štvrťrok", "Fiškálny mesiac", "Rok-Polrok", "Rok-Štvrťrok", "Rok-Mesiac", "Víkend", "Fiškálny rok report", "Fiškálny rok prelom", "Fiškálny rok prelom krátky", "Fiškálny polrok report", "Fiškálny štvrťrok report", "Fiškálny mesiac report", "Index", "Poradové číslo polroka od začiatku", "Poradové číslo štvrťroka od začiatku", "Poradové číslo mesiaca od začiatku", "Je aktuálny dátum", "Je aktuálny týždeň", "Je aktuálny týždeň ISO", "Je aktuálny rok ISO", "Je aktuálny mesiac", "Je aktuálny štvrťrok", "Je aktuálny polrok", "Je aktuálny rok", "Dekáda mesiaca", "Dekáda mesiaca názov" },
    columnNamesCZ = { "Datum", "ID datumu", "Rok", "Rok ISO", "Pololetí", "Čtvrťletí", "Měsíc", "Názov měsíce", "Den", "Den v týdnu", "Názov dne", "Týden", "Týden ISO", "Rok-Týden", "Rok-Týden ISO", "Počet týdnů v předchozích letech", "Pořadové číslo týdne od začátku", "Počet ISO týdnů v předchozích letech", "Pořadové číslo ISO týdne od začátku", "Začátek roku", "Konec roku", "Začátek čtvrťletí", "Konec čtvrťletí", "Začátek měsíce", "Konec měsíce", "Začátek týdne", "Konec týdne", "Dny v měsíci", "Týden v měsíci", "Den v roku", "Přestupní rok", "Fiskální rok", "Fiskální pololetí", "Fiskální čtvrťletí", "Fiskální měsíc", "Rok-Pololetí", "Rok-Čtvrťletí", "Rok-Měsíc", "Víkend", "Fiskální rok report", "Fiskální rok přelom", "Fiskální rok přelom krátky", "Fiskální pololetí report", "Fiskální čtvrťletí report", "Fiskální měsíc report", "Index", "Pořadové číslo pololetí od začátku", "Pořadové číslo čtvrťletí od začátku", "Pořadové číslo měsíce od začátku", "Je aktuální datum", "Je aktuální týden", "Je aktuální týden ISO", "Je aktuální rok ISO", "Je aktuální měsíc", "Je aktuální čtvrťletí", "Je aktuální pololetí", "Je aktuální rok", "Dekáda měsíce", "Dekáda měsíce názov" },
    columnNamesEN = { "Date", "Date ID", "Year", "Year ISO", "Semester", "Quarter", "Month", "Month Name", "Day", "Day of Week", "Day Name", "Week", "Week ISO", "Year-Week", "Year-Week ISO", "Number of Weeks in Previous Years", "Week Sequence Number", "Number of ISO Weeks in Previous Years", "ISO Week Sequence Number", "Start of Year", "End of Year", "Start of Quarter", "End Of Quarter", "Start of Month", "End of Month", "Start of Week", "End of Week", "Days in Month", "Week of Month", "Day of Year", "Is Leap Year", "Fiscal Year", "Fiscal Semester", "Fiscal Quarter", "Fiscal Month", "Year-Semester", "Year-Quarter", "Year-Month", "Weekend", "Fiscal Year Report", "Fiscal Year Turn Of", "Fiscal Year Turn Of Short", "Fiscal Semester Report", "Fiscal Quarter Report", "Fiscal Month Report", "Index", "Semester Sequence Number", "Quarter Sequence Number", "Month Sequence Number", "Is Current Date", "Is Current Week", "Is Current ISO Week", "Is Current ISO Year", "Is Current Month", "Is Current Quarter", "Is Current Semester", "Is Current Year", "Decade of Month", "Decade of Month Name" },
    columnNamesDE = { "Datum", "Datum ID", "Jahr", "Jahrnummer ISO", "Halbjahr", "Vierteljahr", "Monat", "Monatsname", "Tag", "Wochentagsnummer", "Tagsname", "Woche", "Wochennummer ISO", "Jahr-Woche", "Jahr-Woche ISO", "Anzahl von Wochen in vergangenen Jahren", "Wochensordinalzahl", "Anzahl von ISO Wochen in vergangenen Jahren", "ISO Wochensodinalzahl", "Anfang des Jahres", "Ende des Jahres", "Anfang des Vierteljahres", "Ende des Vierteljahres", "Anfang des Monats", "Ende des Monats", "Anfang der Woche", "Ende der Woche", "Tagsanzahl in Monat", "Woche in Monat", "Tag des Jahres", "Ist Schaltjahr", "Geschäftsjahr", "Geschäftshalbjahr", "Geschäftsvierteljahr", "Geschäftsmonat", "Jahr-Halbjahr", "Jahr-Vierteljahr", "Jahr-Monat", "Wochenende", "Geschäftsjahr Report", "Geschäftsjahreswechsel", "Geschäftsjahreswechsel kurz", "Geschäftshalbjahr Report", "Geschäftsvierteljahr Report", "Geschäftsmonat Report", "Index", "Halbjahresordinalzahl", "Vierteljahresordinalzahl", "Monatsordinalzahl", "Ist aktuelles Datum", "Ist aktuelle Woche", "Ist aktuelle ISO Woche", "Ist aktuelles ISO Jahr", "Ist aktueller Monat", "Ist aktuelles Vierteljahr", "Ist aktuelles Halbjahr", "Ist aktuelles Jahr", "Monatsdekade", "Monatsdekadename" },
    columnNamesOriginal = columnNamesEN,
    columnNames = if language = "sk-SK" then columnNamesSK else if language = "cs-CZ" then columnNamesCZ else if language = "en-US" then columnNamesEN else if language = "de-DE" or language = "de-AT" then columnNamesDE else error [Message = "Cannot generate the calendar table.", Detail ="Unsupported language"],
    columnNamesFinal = if columnNamesWithoutDiacritics then List.Transform(columnNames, each Text.FromBinary(Text.ToBinary(_, 1251), TextEncoding.Ascii)) else columnNames,
    finalRenaming = Table.RenameColumns(#"Changed Type1", List.Zip({columnNamesOriginal, columnNamesFinal})),
    result = Table.Buffer(finalRenaming)
in
    result