summarize columns from different tables into a single table

[cwayne758]

Hello,

 I am trying to create a new table. In this new table, I need to have certain columns from each of the tables in the photo. Essentially, I need to create a new table that uses a column from each of these existing ones. Each of these tables has a column that I need to be present in the new table. 

Each of these tables is tied together by a ID (Moves_ID). I have tried using the SUMMARIZE() function, but I am not sure how to approach this.

Can someone offer some advice? Thank you! 

[kcantor]

I would probably create the table in Query Editor using the Merge Queries function. See this link for more information. It is about halfway down the page:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-shape-and-combine-data/