Forum Discussion

PemaChoki's avatar
PemaChoki
Regular Visitor
6 years ago

Create a new table with data from two existing table

i have  two table in the report.The new table will contain the data from table1 and table 2.   The first two column in the new table will be same as the date and c1 from the table.The second column...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Do a left join on the date, and then use FillDown to close the gaps in the cl column.

 

let
    Source = Table.NestedJoin(Table1, {"Date"}, Table2, {"Date"}, "Table2", JoinKind.LeftOuter),
    #"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"cl"}, {"cl"}),
    #"Filled Down" = Table.FillDown(#"Expanded Table2",{"cl"})
in
    #"Filled Down"