Adding a column Automatically once a week into from loaded table into custom table

[muhaiza]

In power bi query, I pulled a table from oracle and named it as Table A. Then I clicked Enter Data option to create a new table named Pareto Table. Next, I scheduled the query to refresh every Monday (once in a week).

How can I schedule to capture a column from Table A into my Pareto Table every time the query refreshed? This means every week, Pareto Table will add new column that it captured from Table A.

For example, after two weeks, I will see in my Pareto Table having two columns added named Monday 1 and Monday 2. These two columns they captured the data from a particular column in Table A.