Forum Discussion

SYM1986's avatar
SYM1986
Helper I
5 years ago
Solved

Column order in data view

Hi all， I have a report，after  i load the data soure. There are five queries，2017，2018，2019，2020, 2021. These queries have the same column order in power query.But afer i apply the querie，four of t...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    With UNION function, columns are combined by position in their respective tables.


    If you want to combine multiple queries into a query, you can also use Append queries in Power Query Editor as an alternative which are combined by column headers.

     

    Regards,
    Community Support Team _ Jing

SYM1986's avatar
SYM1986
Helper I
5 years ago

Hi amitchandak , it affect the DAX of union.

The steps in advance editor now are same, but the queries were added in each year,  so i adjusted some steps before 2021.

I delete all the queries, and reload all the datas, now they have the same order.

thank you.

amitchandak's avatar
amitchandak
Super User
5 years ago

SYM1986 , DAX union can have an impact. You have to use select columns in that case,

 

But best was what you have done.