Create table getting data from table hosted in another query

Hi baironaguillera,

In Power Query Edit window, you want to create a new table including the 3 columns, right? If it is, we are unable to achieve it, we use Query Edit to edit the resource table, you can add costomer, filter resource table, append or merge tables, but can not create a whole new table.

For your requirment, you can filter a resouce table to only have Column1, in the table add two coustomer tables(deperately from 'Query1'[Table1] or Query2'[Table2]).

If you also create a new table by click "New table" under Modeling on PowerBI Desktop Home page.

If this is not what you want, please share your sample data for further analysis.

Best Regards,
Angelia