Forum Discussion

gomezc73's avatar
gomezc73
Helper V
5 years ago
Solved

Combine 2 tables problem

Hello guys,   I have a problem merging two tables, Could you please help me?   Table#1: is a calendar table, only have a column with the date, from 01/01/2014                  Date 1/1/20...
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    gomezc73 - How about this? PBIX is attached below sig

    let
    Source = Table.NestedJoin(Table, {"Date"}, #"Table (2)", {"Effective Date"}, "Table (2)", JoinKind.LeftOuter),
    #"Expanded Table (2)" = Table.ExpandTableColumn(Source, "Table (2)", {"Curr From", "Cur To", "Effective Date", " Exchange Rate "}, {"Table (2).Curr From", "Table (2).Cur To", "Table (2).Effective Date", "Table (2). Exchange Rate "}),
    #"Filled Down" = Table.FillDown(#"Expanded Table (2)",{"Table (2).Curr From", "Table (2).Cur To", "Table (2). Exchange Rate "})
in
    #"Filled Down"
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

gomezc73 - How about this? PBIX is attached below sig

let
    Source = Table.NestedJoin(Table, {"Date"}, #"Table (2)", {"Effective Date"}, "Table (2)", JoinKind.LeftOuter),
    #"Expanded Table (2)" = Table.ExpandTableColumn(Source, "Table (2)", {"Curr From", "Cur To", "Effective Date", " Exchange Rate "}, {"Table (2).Curr From", "Table (2).Cur To", "Table (2).Effective Date", "Table (2). Exchange Rate "}),
    #"Filled Down" = Table.FillDown(#"Expanded Table (2)",{"Table (2).Curr From", "Table (2).Cur To", "Table (2). Exchange Rate "})
in
    #"Filled Down"