Calculated Table Column Order

[tecumseh]

Hi all,

Can I control the order of the Columns in a calculated column?
In my DAX, I have the Date field listed 2nd in order, but the output shows the date column 3rd in order.

Thanks,

Try_1 = 
Summarize(
    FILTER(
        Sales,
        Sales[Channel] = "Education" &&
        Sales[Customer] <> "Adjustment" &&
        Sales[Net Revenue] > 0
    ),
    Sales[Customer Group ID],
    Sales[Begin Quarter Date],
    "Revenue",[Net Revenue]
)

[parry2k]

@tecumseh this is strange and ofcourse shouldn't require 2nd table to maintain the order of the columns. I will test it at my end and see if I can find anything. Super strange.

[parry2k]

@tecumseh not sure if the order of the columns matters but I'm surprised why it is showing as 3rd instead of 2nd. You can wrap summarize in SELECTCOLUMN function and get the columns in the order you want.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

[tecumseh]

Thanks parry2K,

I tried wrapping in SELECTCOLUMNS.
It did not work, still returning Revenue as 2nd column and the date as the 3rd column.

I played with it a bit more.
Now Revenue is 1st Column, Group ID is 2nd Column, Date is 3rd Column.
Even though I specified the complete opposite order in SELECTCOLUMN Wrapper.

I created a new Calulcated Table which refers to the 1st Calculated Table
Now the columns are in the correct order.
Seems I should not have to do this drastic step

DAX for 2nd Calc Table:

Try_2 = 
SELECTCOLUMNS(
Try_1,
"Customer Group ID", Try_1[Customer Group ID],
"Begin Quarter Date", Try_1[Begin Quarter Date],
"Revenue", Try_1[Revenue]
)