how to union multiple tables same column name but not same order

[Anonymous]

hello

My first table has the following fields in that order

employeeid, fullname, managerid, managername, herachypath, hierachydepth, level1, level2, level3, ..., allLevelSort, isleaf

while the second table has the same field but they are alphabetically sort.

When I want to create a new table  allManagers=union('dim manager Level 1' ,'dim manager level2 ') it gives stange things.

Does someone know how to solve this isssue.

[amitchandak]

What is the exact issue you are facing

[Anonymous]

if in the second table the order is not exactly the same as in dim manager level1, for ex: 

HierarchyDepth", 'dim Manager Level 1'[HierarchyDepth],  when I create a global table using a union, it add the wrong fields.

Is there a way to avoid that

[Anonymous · Accepted solution]

Hi @Anonymous,

For Dax formulas, current you can only use 'SELECTCOLUMNS', 'SUMMARIZE', 'GROUPBY' functions to choose columns and define the order of the columns in variable tables and merge them with union functions.

Table = UNION(GROUPBY(T1,[1],[2],[3],[4],[5]),GROUPBY(T2,[1],[2],[3],[4],[5]))

In addition, you can also do merge table operation in query edit, it allows you to change the order of columns.

let
    Source = Table.Combine({@T1,Table.ReorderColumns(@T2,Table.ColumnNames(@T1))})
in
    Source

Regards,

Xiaoxin Sheng