Forum Discussion

andywil456's avatar
andywil456
Advocate II
9 years ago
Solved

union formula column section error

I have 3 sharepoint files all with a number of excel tables. All the tables are in the same format and layout, for each field sale to complete. the 3 sharepoint files cover different periods but the ...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    andywil456

     

    In DAX, when using UNION(), columns are combined by position in their respective tables. And column names in the return table will  just match the column names in table_expression1. So make sure columns in two tables has same order. In your scenario, I suggest you go to Query Editor, "move" columns under Transform tab. 

     

    Then you can use "Append Query" to combine two datasets together.

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

andywil456

 

In DAX, when using UNION(), columns are combined by position in their respective tables. And column names in the return table will  just match the column names in table_expression1. So make sure columns in two tables has same order. In your scenario, I suggest you go to Query Editor, "move" columns under Transform tab. 

 

Then you can use "Append Query" to combine two datasets together.

Regards,