Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Merge Multiple tables into one?

Hi, I have 3 tables which I want to merge (based on Date and Loan) into a single table using Power BI Edit query. Sample tables: Output Table: Date Loan Close Started App 5/15/2018 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Try this, Table23, Table24 and Table25 are your source tables.

     

    let
    Source = Table.Combine({Table23, Table24, Table25}),
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[MileStone]), "MileStone", "Count", List.Sum),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"Started"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,0,Replacer.ReplaceValue,{"App"}),
    #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1",null,0,Replacer.ReplaceValue,{"Close"})
in
    #"Replaced Value2"
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Do you want this in M or DAX?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks For your reply! I want this in M.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Try this, Table23, Table24 and Table25 are your source tables.

     

    let
    Source = Table.Combine({Table23, Table24, Table25}),
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[MileStone]), "MileStone", "Count", List.Sum),
    #"Replaced Value" = Table.ReplaceValue(#"Pivoted Column",null,0,Replacer.ReplaceValue,{"Started"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,0,Replacer.ReplaceValue,{"App"}),
    #"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1",null,0,Replacer.ReplaceValue,{"Close"})
in
    #"Replaced Value2"