Forum Discussion
summarize columns from different tables into a single table
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!
1 Reply
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/
