Forum Discussion
EduG
Apr 01, 2025Copper Contributor
Transform a table using Power Query
Hi, I have a table that looks like this: Name Start End Anna 01-Jan-2024 15-Mar-2024 Mike 16-Feb-2024 30-Apr-2024 Sean 01-Mar-2024 31-Mar-2024 which I would like t...
OliverScheurich
Apr 02, 2025Gold Contributor
let
Source = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Start", type date}, {"End", type date}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Benutzerdefiniert", each List.Distinct(List.Transform({Number.From([Start])..Number.From([End])}, each Date.StartOfMonth(Date.From(_))))),
#"Expanded {0}" = Table.ExpandListColumn(#"Added Custom", "Benutzerdefiniert"),
#"Renamed Columns" = Table.RenameColumns(#"Expanded {0}",{{"Benutzerdefiniert", "Period"}}),
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Start", "End"})
in
#"Removed Columns"This code returns the intended result in my sample file. For column Period in the green result table i've selected costum format MMM YYYY.