Combine the same columns from different table

[Anonymous]

Hi ! I found this link, that's exactly what I want to do but for more than one column in common. 
https://community.powerbi.com/t5/Desktop/Combine-the-Same-Columns-from-Three-Tables-into-One-Slicer/...
In this example , the user only have the "contract number" in common, and i have more: ID, Title...etc I want to merge these differents columns in a new table
I tried to change the formula to do what I want but it appears that I'm not that good with DAX ... Is that possible, and if yes can anyone help me? 

Thanks!

[Deepak_Kavin]

I need to combine These three Table with same Coulmn names into a new table

I tried to Create but as per the below Solution

But it is showing below error

 Please help me on this

[dax · Accepted solution]

Hi HugoDEVILLIER,

According to your dscription, it seems that you want to  combine specific columns from different tables into a new table, right?

If so, you could try below M code

let
    Source = Table.Combine({Table.FromColumns({c1[name],c1[status]},{"Table1 Column1","Table1 Column2"}), 
    Table.FromColumns({c2[cname],c2[descrip]}, {"Table1 Column1","Table1 Column2"}),
    Table.FromColumns({t2[month],t2[ltm]}, {"Table1 Column1","Table1 Column2"})})
    in
    Source

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, 
Yes ! That's perfect I would never have found by myself, Thank you so much!

HD