Summarize Table column order

[boehnc]

I am trying to union two tables (CMSum1 and CMSum2).

Any reason why the grouping column order is different than the way they are ordered here? Seems to be ok for CMSum2


CMSum1 = SUMMARIZECOLUMNS(CoreMeasure[YearMo],CoreMeasure[Pop Health Area],CoreMeasure[Division],CoreMeasure[CM Category],CoreMeasure[Measure], CoreMeasure[HiLow],FILTER(CoreMeasure,CoreMeasure[MetricType]=1),
"Num",SUM(CoreMeasure[PassFailChg]),
"Denom",CALCULATE(COUNTROWS(CoreMeasure)),
"Value",CALCULATE(sum(CoreMeasure[PassFailChg])/COUNTROWS(CoreMeasure)
))

 

[Matt Allington]

I have no idea what you are asking, however I believe when you Union 2 tables, the first table columns are used to set the order and the second table column order is ignored, and the physically position of the columns are appended. Eg, if your first table is

colA, ColB
3,4
2,1

and your second table is
colB, ColA
5,6
7,8

I believe you will get
colA, ColB
3,4
2,1
5,6
7,8

you should test this, but that is my understanding.