Forum Discussion
Union column order
I'm trying to use the UNION function with two summarized tables and a third table. The first two tables are summarized in the exact same way, and their resulting column order is also the same. Th...
P3Tom
Helper I
Helper IFrom the documentation, regarding UNION, it says: Columns are combined by position in their respective tables.
So you could use SUMMARIZE with TableB like:
Table F =
UNION (
SUMMARIZE ( TableA, TableA[a6], TableA[a8x], "hits", COUNT ( TableA[a5] ) ),
SUMMARIZE ( TableB, TableB[b2], TableB[b1], TableB[b3x] )
)
At least the columns order is predictable.
Tom
I tried this, but similar to using SELECTCOLUMNS, the calculated column still wants to become the first column.