Forum Discussion
MadhuKumar
3 years agoHelper II
Power BI Union issue
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
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
1 Reply
- PhilipTreacySuper User
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