let
Source = Excel.CurrentWorkbook(){[Name="tbl_LandRent"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Type", type text}, {"Name", type text}, {"1/1/2023", Int64.Type}, {"2/1/2023", Int64.Type}, {"3/1/2023", Int64.Type}, {"4/1/2023", Int64.Type}, {"5/1/2023", Int64.Type}, {"6/1/2023", Int64.Type}, {"7/1/2023", Int64.Type}, {"8/1/2023", Int64.Type}, {"9/1/2023", Int64.Type}, {"10/1/2023", Int64.Type}, {"11/1/2023", Int64.Type}, {"12/1/2023", Int64.Type}}),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Type", "Name"}, "Attribute", "Value"),
#"Renamed Columns" = Table.RenameColumns(#"Unpivoted Other Columns",{{"Attribute", "Date"}, {"Value", "Rent"}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}})
in
#"Changed Type1"
3. Add the new table to the data model
Bookmarks