Merge Multiple tables into one?

[Anonymous]

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	115	1	1	0
5/13/2018	113	1	0	1
5/22/2018	122	1	1	1
5/28/2018	128	1	1	0
5/19/2018	119	0	0	1

I would really appreciate any help, thanks a ton!

Warm Regards,

Shikha

[Greg_Deckler]

Do you want this in M or DAX?

[Anonymous]

Thanks For your reply! I want this in M.

[Greg_Deckler · Accepted solution]

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"