Power BI Union issue

[MadhuKumar]

Hi Team,

I have reorder the columns in the report don't want to use DAX because i have many columns in the each table so i just want to make the report automated.I want to reorder the columns as Column1.Column2,column3 .Please,refer the below screenshot.

For example

Table1 the column order is A,B,C

and

Table2 the column order is A,C,B .

Could anyone please help me on this?

I want change the Table2 order as Table1

[PhilipTreacy · Accepted solution]

Hi @MadhuKumar 

Download example PBIX file with tables and code

Add a step for the Table2 query :

= Table.ReorderColumns(Source,Table.ColumnNames(Table1))

regards

Phil