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

amitchandak's avatar
amitchandak
Super User
5 years ago

SYM1986 , does column order matter for you here(date studio)?

It can change based on the order columns are added or removed.

You may have to check all steps in advance editor (right-click in power query on the table and open it)

 

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.