let
Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Сотрудник", type text}, {"Дата приема", type date}}),
#"Calculated Age" = Table.TransformColumns(#"Changed Type",{{"Дата приема", each Date.From(DateTime.LocalNow()) - _, type duration}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Calculated Age",{{"Дата приема", Int64.Type}}),
#"Changed Type2" = Table.TransformColumnTypes(#"Changed Type1",{{"Дата приема", type date}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Changed Type2", "Дата приема", "Дата приема - Copy"),
#"Duplicated Column1" = Table.DuplicateColumn(#"Duplicated Column", "Дата приема - Copy", "Дата приема - Copy - Copy"),
#"Added Custom" = Table.AddColumn(#"Duplicated Column1", "Custom", each [Дата приема]-1900),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Custom"}),
#"Inserted Year" = Table.AddColumn(#"Removed Columns", "Year", each Date.Year([Дата приема]), type number),
#"Added Custom1" = Table.AddColumn(#"Inserted Year", "Custom", each [Year]-1900),
#"Removed Columns1" = Table.RemoveColumns(#"Added Custom1",{"Дата приема", "Year"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Custom", "Year"}}),
#"Reordered Columns" = Table.ReorderColumns(#"Renamed Columns",{"Сотрудник", "Year", "Дата приема - Copy", "Дата приема - Copy - Copy"}),
#"Inserted Month" = Table.AddColumn(#"Reordered Columns", "Month", each Date.Month([#"Дата приема - Copy"]), type number),
#"Inserted Day" = Table.AddColumn(#"Inserted Month", "Day", each Date.Day([#"Дата приема - Copy - Copy"]), type number),
#"Removed Columns2" = Table.RemoveColumns(#"Inserted Day",{"Дата приема - Copy", "Дата приема - Copy - Copy"}),
#"Removed Blank Rows" = Table.SelectRows(#"Removed Columns2", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Changed Type3" = Table.TransformColumnTypes(#"Removed Blank Rows",{{"Year", type text}, {"Month", type text}, {"Day", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type3","","",Replacer.ReplaceValue,{"Year"}),
#"Lowercased Text" = Table.TransformColumns(#"Replaced Value",{{"Year", Text.Lower}}),
#"Uppercased Text" = Table.TransformColumns(#"Lowercased Text",{{"Year", Text.Upper}}),
#"Added Suffix" = Table.TransformColumns(#"Uppercased Text", {{"Year", each Text.From(_, "lt-LT") & " г.", type text}}),
#"Added Suffix1" = Table.TransformColumns(#"Added Suffix", {{"Month", each Text.From(_, "lt-LT") & " м.", type text}}),
#"Added Suffix2" = Table.TransformColumns(#"Added Suffix1", {{"Day", each Text.From(_, "lt-LT") & " д.", type text}}),
#"Added Custom2" = Table.AddColumn(#"Added Suffix2", "Custom", each [Year] &[Month] &[Day]),
#"Removed Columns3" = Table.RemoveColumns(#"Added Custom2",{"Сотрудник", "Year", "Month", "Day"}),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Columns3",{{"Custom", "Стаж"}})
in
#"Renamed Columns1" |